Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> help with a global query

help with a global query

From: adam schwartz <adam_at_e-and-c.com>
Date: Sun, 23 Aug 1998 14:47:14 +0300
Message-ID: <35E00142.1E9084DA@e-and-c.com>


Hi,

Is it possible to search for an item in all the tables of the database at once?

e.g. I want to see all the occurences of '#' in all the columns in all the tables in the database. Is ther a way to write this w/o having to hardcode each table and column in the DB?

thanks
adam Received on Sun Aug 23 1998 - 06:47:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US