Name
DESCRIBE
Synopsis
DESC[RIBE] [schema.]object_name[@database_link_name]
The DESCRIBE command displays information about a table, a view, an object type, a stored package, a stored procedure, a stored function, or a synonym. For example:
DESCRIBE employee DESCRIBE jenny.employee DESCRIBE employee@other_db
Parameters
- schema
The name of the object’s owner.
- object_name
The name of the object that you want to describe.
- database_link_name
The name of a database link pointing to the database in which the object exists.
See also: SET DESCRIBE (under SET).
Get Oracle SQL Plus Pocket Reference, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.