Monday, August 11, 2008

Select column name from table

To select column names of a given table you can use the following query:

Select column_name
from user_tab_cols
where table_name ='TABLE_NAME';

Remember the table name should be in capital letters.

No comments: