O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Displaying the structure of a table using DESCRIBE

If, by now, in doing the examples in this chapter, you've received an error when incorrectly typing a column or table name (as is common), it should be obvious that SQL requires that we be syntactically accurate when listing each element of the statement. All clauses, keywords, column names, and table names must be spelled correctly. This can be difficult to do if you don't know what the column names are. Although our SQL Developer tool makes this easy to find, we also have the DESCRIBE command to display the structure of a table, as shown in the following screenshot:

Displaying the structure of a table using DESCRIBE

Executing the command produces ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required