Desc Table in Oracle Example SQL


Desc Table in Oracle Example SQL


After Creating table, everyone wishes to see the structure of the table. In this post Desc Table in Oracle Example SQL, we will discuss how to view the structure of an existing table in SQL. 

 

To view the structure of an existing table in SQL, we have to use DESC Table Command. After supplying this command you can see the structure of the table.

 

General Syntax of DESC Table in Oracle 


Desc table-name;

 

Example : Suppose we wish to view the structure of student table, we have to write it as :

Desc student;