OraFAQ Forum: SQL & PL/SQL » query to retrieve 'COLUMN' names in a table

Home » SQL & PL/SQL » SQL & PL/SQL » query to retrieve 'COLUMN' names in a table

Thu, 18 December 2003 00:11

resy
Messages: 86
Registered: December 2003

Member

hi,

Can anybody tell me how to write a query to retrieve all the column names of a table?

thanx.

Thu, 18 December 2003 00:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Select column_name
  From user_tab_columns
 Where table_name = 'YOUR_TABLE';

As in most of these cases, ALL_TAB_COLUMNS and DBA_TAB_COLUMNS exist too.

MHE

Thu, 18 December 2003 00:58

resy
Messages: 86
Registered: December 2003

Member

tanQ

Previous Topic:	Where the procedure gets stored into the database?
Next Topic:	ARRAYS, HTP.FORMHIDDEN

Goto Forum:

]

Current Time: Fri Apr 26 01:59:45 CDT 2024