René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

describe [SQL*Plus]

SQL> desc table_name
SQL> desc view_name
SQL> desc procedure_name
SQL> desc function_name
SQL> desc package_name
SQL> desc object_name
describe shows information about the previously meantioned database objects.
desc is the abbreviation for describe.

Settings that affect the output of desc

SQL> set describe depth 2
SQL> set describe indent on
SQL> set describe line off 

Links