SQLPlus Describe

DESCRIBE Command Syntax:

DESC[RIBE] {[schema.]object[@connect_identifier]}

DESCRIBE Command Examples:

DESCRIBE table_name
DESCRIBE package_name

CREATE TYPE suppliers AS OBJECT
(supplier_id NUMBER(12),
supplier_name VARCHAR2(250),
city VARCHAR2(100)
);

DESCRIBE suppliers