How to get column names from table

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 = 'MYTABLE'

Credit to: https://stackoverflow.com/questions/452464/how-can-i-get-column-names-from-a-table-in-oracle