Paxenos Paxenos - 4 months ago 7
SQL Question

How can I get column names from a table in Oracle?

I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named

EVENT_LOG
that contains
eventID
,
eventType
,
eventDesc
, and
eventTime
, then I would want to retrieve those field names from the query and nothing else.

I found how to do this in:



But I need to know: how can this be done in Oracle?

Answer

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'
Comments