Introduction to SQL

The remainder of this chapter is broken up into various sections, each section covering important parts of the SQL language. Each section will build on knowledge gained from the prior section. You will learn how to create SQL queries, create tables/indexes/various database objects, set the correct SQL permissions, and learn the basics of SQL*Plus reporting. This SQL primer will help you understand the syntax used to create the Sales Tracking application table, index, triggers, and referential integrity.

The DESCRIBE command is very useful for showing the column names and attributes of specific tables. This same information can be viewed by selecting from user_tab_columns. DESCRIBE or DESC for short is easy to remember and ...

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.