Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 5. Using SQL*Plus > Viewing the Structure of a Table
Viewing the Structure of a Table
You use the DESCRIBE command to view the structure of a table. You can save some typing by shortening the DESCRIBE command to DESC (DESC [RIBE]). Knowing the structure of a table is useful because you can use the information to formulate a SQL statement. For example, you can figure out the columns you want to query in a SELECT statement.
Note
You typically omit the semicolon character (;) when issuing SQL*Plus commands.
