Oracle_ch2_Morrison

Oracle_ch2_Morrison - Chapter 2: Creating and Modifying...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 2: Creating and Modifying Database Tables Jason C. H. Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258 chen@jepson.gonzaga.edu
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems - Dr. Chen TM Oracle-2 Objectives h Become acquainted with Structured Query Language (SQL) e Learn about Oracle10g user schemas e Learn how to define Oracle10g database tables e Create database tables using SQL*Plus e Learn how to debug Oracle10g SQL commands and use Oracle Corporation online help resources e Learn how to view information about your database tables using Oracle10g data dictionary views e Modify and delete database tables using SQL*Plus
Background image of page 2
Business Database Systems - Dr. Chen TM Oracle-3 Database Objects and Queries h An Oracle database consists of multiple user accounts e Each user account owns database objects h Tables e Views e Stored programs, etc. Query: command to perform operation on database object Structured Query Language (SQL) e Industry standard query language for most of relational databases e Consists of about 30 commands e SQL-99 Most recent version
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems - Dr. Chen TM Oracle-4 Basic SQL Concepts and Commands SQL (Structured Query Language) is used to manipulate the database. There are two basic types of SQL commands: DDL commands work with the structure of the objects (tables, indexes, views) in the database. DML commands work with the data in the database (i.e.,manipulate the data). Reserved words - SQL command words e Data ___________ Language ( DDL ) e Data ___________ Language ( DML )
Background image of page 4
Business Database Systems - Dr. Chen TM Oracle-5 SQL Components D__L D__L D__L D.B. ORACLE (SQL Components)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems - Dr. Chen TM Oracle-6 DDL Commands h Used to ______ and ______ the structure of database objects e CREATE e ALTER e DROP e GRANT e REVOKE e DDL commands execute as soon as they are issued, and do not need to be explicitly saved
Background image of page 6
Business Database Systems - Dr. Chen TM Oracle-7 DML Commands h Used to insert, view, and modify database data e INSERT e UPDATE e DELETE e SELECT e DML commands need to be explicitly saved or rolled back (ch.3) e COMMIT e ROLLBACK e SAVEPOINT
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems - Dr. Chen TM Oracle-8 Security - Granting Table Privileges h Security is the prevention of unauthorized access to the database. Within an organization, the database administrator determines the types of access various users need for the database. e Some users might be able to retrieve and update data in the database. Other users might be able to retrieve any data from the database but not make any changes to it. Still other users might be able to access only a portion of the database .
Background image of page 8
Business Database Systems - Dr. Chen TM Oracle-9 Oracle10g User Accounts h User ______ - identified by a unique username and password e User _____ - all of the objects that the user creates and stores in the database e Database _____ e Also called schema objects e Objects in user schema e Object owner has privileges to perform all possible actions on an object
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems - Dr. Chen TM Oracle-10 Break Time: SQL Plus Oracle SQL command line utility for issuing SQL commands Starting SQL Plus LOGON to YOUR Oracle Account
Background image of page 10
Business Database Systems - Dr. Chen
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 78

Oracle_ch2_Morrison - Chapter 2: Creating and Modifying...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online