Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ** help with query?
"Jack" <jackbader_at_gmail.com> wrote in message
news:1141428494.577471.286160_at_e56g2000cwe.googlegroups.com...
> All,
>
> Is there one simple query that could be used to search all tables in
> the dictionery to find every occurance of the value...let's say "xyz"
> or the number 25.
>
> Thanks,
> Jack
>
> ps. you can probably tell I don't know squat about SQL
>
Not really. You want to look in the entire database in every row and column
for a particular string? What value would that be. You could use strings
and just search the database files.
Jim
Received on Fri Mar 03 2006 - 18:47:35 CST