Oracle SQL*Plus Pocket Reference

Name

DESCRIBE

Synopsis

DESC[RIBE] [schema.]object_name
           [@database_link_name]

The DESCRIBE command is used to display information about a table, a view, an Oracle8 object type, a stored package, a stored procedure, or a stored function. For example:

DESCRIBE employee
DESCRIBE jenny.employee
DESCRIBE employee@other_db

Parameters

schema

Is the name of the object’s owner.

object_name

Is the name of the object that you want to describe.

database_link_name

Is the name of a database link pointing to the database where the object exists.