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
Share this Page URL
Help

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.



  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint