How to select field name

[Cantor]

Hello,short question: Is it possible to select only the fiel name?shorter question: How?Thanx,Cantor

 

[DrSql]

Please describe the question else it is tough to respond.<br>Thank you <p>Dr. Sql<br><a href=mailto:vpathisseril@yahoo.com>vpathisseril@yahoo.com</a><br><a href= > </a><br>Good Luck.

 

[MalcolmW]

Cantor,<br>Try posting a sample SELECT statement (whether it works or not), and what you want to achieve with it. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[nagendra]

hi,<br>&nbsp;&nbsp;I am nagendra,here is some solution, check out useful <br>&nbsp;&nbsp;or not one view is available in oracle database dictionary<br>&nbsp;&nbsp;called user_tab_columns, using this view we can select<br>&nbsp;&nbsp;column names belongs to specific table.<br><br>&nbsp;Ex:<br>&nbsp;&nbsp;select column_name<br>&nbsp;&nbsp;from&nbsp;&nbsp;&nbsp;user_tab_columns<br>&nbsp;&nbsp;where&nbsp;&nbsp;table_name = 'EMP'<br><br>&nbsp;&nbsp;regards<br>&nbsp;&nbsp;Nagendra P.<br>&nbsp;&nbsp;<A HREF="mailto:naga_p@hotmail.com">naga_p@hotmail.com</A>

 

[shyamal]

Try:<br><br>Select * from mytable<br>where 1=0<br><br>This returns field names only.