How to display a description of a table in Oracle SQL?-CodePudding

I have to display description of a table in Oracle SQL like below. How can I do that?

I have tried SELECT * FROM ALL_TAB_COMMENTS WHERE table_name = 'abc' but that is not the SQL command for get the the output like below.

Name        Type        Nullable    Default Id  Comments
------- ----------- ------------    ---------   ---------
ABC     VARCHAR2(30)    NOT NULL    1   
PQR     VARCHAR2(2000)  NOT NULL    2   
XYZ     VARCHAR2(30)                3

CodePudding user response：

The thing you look for is probably

Disclaimer: I'm the product manager at Oracle for our database tools including SQLcl and SQL Developer