Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get column names from sql query

844545Aug 18 2011 — edited Aug 19 2011
Hello ...
I have a query and I need to get the names of its columns without having to hard code them.

example:
cursor blah is select A.emp, B.num, C.tel, B.jack from table1 A, table2 B, table3 C;

the way I have it now is like this (I am using a HTML table for an automailer)

<tr>
<td><b> emp </b></td>
<td><b> num </b></td>
<td><b> tel </b></td>
<td><b> jack</b></td>
</tr>

I want something to loop through and get me all the column names. So I dont have to mess with the HTML code when I add or remove columns from my query

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2011
Added on Aug 18 2011
3 comments
686 views