SQL*Plus Tutorial


SqlPlus Describe table

The command DESCRIBE lists the specifications for a table, view, synonym, procedure or function from an Oracle database.

SQLplus Describe



CREATE TABLE BOOKS

(ID NUMBER(38),

NAME VARCHAR2(100) NOT NULL,

PRICE NUMBER(38)

);

DESCRIBE books