Home » SQL & PL/SQL » SQL & PL/SQL » find column name of specific value in a table (200 columns)
find column name of specific value in a table (200 columns) [message #188841] Tue, 22 August 2006 01:46 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
I have table with 200 column in oracle 8i (windows 2000)
Now i want to know the column name of specific value in a table .

For example
i have table like
select * from test_find_1;
A B C D
1 Orange Grape Papaya
2 Apple Pear Coconut
3 Mango Lime Banana

i want to know the column name of Pear
Please help
Re: find column name of specific value in a table (200 columns) [message #189257 is a reply to message #188841] Wed, 23 August 2006 17:22 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:5203164092530
Re: find column name of specific value in a table (200 columns) [message #189270 is a reply to message #188841] Wed, 23 August 2006 23:29 Go to previous messageGo to next message
reyazan
Messages: 53
Registered: February 2005
Member
thanks a lot
Re: find column name of specific value in a table (200 columns) [message #189523 is a reply to message #188841] Fri, 25 August 2006 00:33 Go to previous message
venkatbollu
Messages: 53
Registered: April 2005
Location: Bangalore
Member

Hi friend,

Plz find the attachment and let me know if u have any issues.

Thks & Rgds
Venkat
Previous Topic: passing string array to stored proc
Next Topic: Regular Expressions
Goto Forum:
  


Current Time: Sun Dec 04 10:59:49 CST 2016

Total time taken to generate the page: 0.08340 seconds