| |
GeekInterview.com > Tech FAQs > PL/SQL
| Print | |
Question: Hello,
I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.
Example
Table having fields like columnA, columnB, columnC, columnD,
..........columnN and all have the same dataType. and you dont know in which field your data exists.
suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.
Is it possible that we can make a query to search the data
Umair Tariq
|
| June 06, 2007 23:22:32 |
#3 |
| Chinmay |
Member Since: Visitor Total Comments: N/A |
RE: Hello,I need some info, that is it possible ...
|
Yes,
you can do by
using like with or
like
select * from tab1
where col1 like '%back%'
or col2 like '%back%'
or col3 like '%back%'
or col4 like '%back%'
|
| |
Back To Question | |
