August 2002
Intermediate to advanced
528 pages
10h 12m
English
The next chapter begins the discussion of Oracle’s structured query language. The chapter deals with the part of the language that is used to create the database objects.
The chapter opens with a discussion of SQL*Plus and the SQL editor. SQL*Plus is Oracle’s workhorse product for talking with the database. You will see how to log on to SQL*Plus and how to execute commands to the Oracle database. The chapter will then discuss the various database objects, how to create and maintain the objects, and how to use Oracle’s constraints to ensure database integrity. The commands used to maintain the database are part of the Data Definition Language that Oracle uses.
The last part of the chapter covers Oracle’s Data Control Language (DCL) ...