(?) on querying 'columns'
Date: 1995/10/05
Message-ID: <DFzux9.1wA_at_onyx.indstate.edu>#1/1
This may sound awkward, but here is what I want to do:
I need to be able to select everything from a table and for all
VARCHAR2 datatypes that are greater than <n> length to look in that
column for a specific string. I need to search every column in a table.
This is not just one table, but about one thousand of them.
Has anyone done this? Or knows of an easy way?
This may be in a FAQ somewhere, if so, where?
I am coming back up to speed on SQL, but remembering old tricks is hard.
Using Oracle 7.x on an HP-UX 9000.
--
.---------------------------------------------------------------------------.
| Paul Cardwell | email: arc_at_mama.indstate.edu |
|________________________.-------------------------.________________________|
`--http://mama.indstate.edu/users/arc---*---OS/2 WARP / Linux / AmigaCD32---'
Received on Thu Oct 05 1995 - 00:00:00 CET