You can query the USER_TAB_COLUMNS table for table column metadata.
SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = ‘My_Talbe_Name’
See also:
How to get column names from Sql Server table
How to get column names from DB2 table
How to get column names from Mysql table
How to get column names from PostgreSQL table
How to get column names from SQLite table
Some Oracle tools you can try: https://www.withdata.com/oracle/
