• After creating the table and/or insert the data into the table, you can check your product by using
• SQL⁺ command, 'DESCRIBE' to list the column definitions for a table or view.

Synopsis: DESC[RIBE] [user.]table

For instance,
SQL> describe student;

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                                     VARCHAR2(30)
 STUDENTNUMBER                   NOT NULL NUMBER(4)
 CLASS                                    NUMBER(4)
 MAJOR                                    VARCHAR2(4)

• SQL command, 'SELECT' to list the data from the table. For instance,

SQL> SELECT * FROM STUDENT;
NAME                           STUDENTNUMBER      CLASS MAJO
------------------------------ ------------- ---------- ----
Smith                                     17          1 COSC
Brown                                      8          2 COSC
Senior Answer1                           421          5 COSC
Dick Davidson                            110          1 COSC
Babara Benson                             28          2 ECSE
Charlie Cooper                            21          2 DCSC
Katherine Ashly                          138          1 COSC
Benjamin Bayer                           430          5 EPW
Senior Crew                              492          5 COSC
John                                     362          3 CIVI
Proc                                     123          1

11 rows selected.

Exit to : Oracle Hints and Tips