To get all column names of a Table in Oracle you can use the following snippet.

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'TABLENAME'

If you are using MSSQL, take a look at this snippet -> How to list all columns from a table in MSSQL

4 thought on “How to get all column names of a Table in Oracle”

Leave a Reply