faqts : Computers : Programming : Languages : PHP : Database Backed Sites : Oracle

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 8 people (25%) answered Yes
Recently 2 of 8 people (25%) answered Yes

Entry

How do i return the column names by using the name of a table?

Oct 1st, 2005 09:26
Martin Vrbovsky, Emily Lyon,


There are more possiblieties:
e.g. SELECT owner, table_name, column_name FROM all_tables WHERE
table_name = UPPER('TABLE')
or
in sqlplus: desc TABLE
or via JDBC - using JDBC API...
Hope this helped.
Regards.