How to view the structure of a table in Oracle?

1 year ago

Benjamin Taylor

1 minute

To view the structure of a table in an Oracle database, you can use the following SQL statement:

DESCRIBE table_name;

Or, alternatively

SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'table_name';

Replace table_name with the name of the table you want to view the structure of.