Home » SQL & PL/SQL » SQL & PL/SQL » how to find out column names ?
how to find out column names ? [message #239702] Wed, 23 May 2007 02:37 Go to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
is there any views to find column name details for the selected tables?


regards Muthu
Re: how to find out column names ? [message #239706 is a reply to message #239702] Wed, 23 May 2007 02:44 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

select column_name from all_tab_columns where table_name='your table'
Previous Topic: Materialized view ON COMMIT 12054 error - but it almost works!
Next Topic: how to get the two agregate count from two columns through the same query?
Goto Forum:
  


Current Time: Sun Aug 20 06:53:57 CDT 2017

Total time taken to generate the page: 0.09938 seconds