SQL> desc dept
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------------

 DEPTNO                                    NOT NULL NUMBER
 DNAME                                              VARCHAR2(15)
 LOC                                                VARCHAR2(15)


 select * from dept;

DEPTNO DNAME           LOC
------ --------------- ---------------
    10 ACCOUNTING      NEW YORK
    20 RESEARCH        DALLAS
    30 SALES           CHICAGO
    40 OPERATIONS      BOSTON