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: 64111
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: Interaction between type inheritance and nested tables
Next Topic: := or =
Goto Forum:
  


Current Time: Mon Dec 05 14:54:14 CST 2016

Total time taken to generate the page: 0.10676 seconds