Home » SQL & PL/SQL » SQL & PL/SQL » find value from table (windowsxp oracle 9i form 6i)
find value from table [message #360463] Fri, 21 November 2008 02:13 Go to next message
anasjamil
Messages: 28
Registered: April 2008
Location: KARACHI
Junior Member

hi,
i want to find a value "abc" from a table having 50 columns but
i forgot the column name.so how to retrieve the data as well as
column name with it.

e.g

col1 col2 col3 col4 col5

1a 2a 3a 4a 5a
1b 2b 3b 4b 5b
1c 2c 3c 4c 5c

like above i want to find "3b" but dont know the colum

regards,
anas jamil
Re: find value from table [message #360478 is a reply to message #360463] Fri, 21 November 2008 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5203164092530

Regards
Michel
Re: find value from table [message #360750 is a reply to message #360478] Sun, 23 November 2008 22:22 Go to previous message
anasjamil
Messages: 28
Registered: April 2008
Location: KARACHI
Junior Member

hi,
Thanks Michel i got it.


regards,
anas jamil
Previous Topic: use varchar2 value as cursor elements ..
Next Topic: "if condition" and "how to get output" (merged)
Goto Forum:
  


Current Time: Mon Aug 21 07:17:48 CDT 2017

Total time taken to generate the page: 0.05742 seconds