Get column name for a table

Question

I want a query that returns me name of columns of a table.

I tried following query -

SELECT column_name ColName 
  FROM all_tab_columns 
 WHERE table_name ='<TABLENAME>';

but this query is returning duplicate column names.

I do not want to use distinct in my query cause it hampers the performance.

So is there a query which returns columns of a table without any duplicate.

Are you sure you don't have more than one table named '' owned by different schemas? Try adding `OWNER = ''` to your where clause. — Ollie, Apr 05 '12 at 09:40
Right please filter this with owner too ,and you'll get the desired output — Gaurav Soni, Apr 05 '12 at 09:40
possible duplicate of [How can I get column names from a table?](http://stackoverflow.com/questions/452464/how-can-i-get-column-names-from-a-table) — DCookie, Apr 05 '12 at 16:30

score -1 · Answer 1 · edited Apr 18 '12 at 05:41

-1

This is the solution for getting column name from table.

    select column_name,data_type from cols where Table_name='TEST_TABLE'

edited Apr 18 '12 at 05:41

Sathyajith Bhat

answered Apr 05 '12 at 09:38

Vishal Ranapariya

1 Answers1