You can query the data dictionary views to get information about the columns in a particular table.
In an Oracle database, the basic column information is kept in the data dictionary view called
USER_TAB_COLUMNS, for the columns in the tables owned by your schema.
The most common columns in this particular view are:
WHERE USER_TABLES.TABLE_NAME =
ORDER BY USER_TABLES.TABLE_NAME
This returns all the tables for the user along with their columns.
The next lesson teaches you how to modify a table that already exists in your Oracle database.
Click the link below to read about the characteristics in the data dictionary views.
Data Dictionary Views