Re: Searching for tables in View definitions

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Mon, 10 Aug 1998 20:33:12 GMT
Message-ID: <6qnlek$26v$1@trader.ipf.de>

On Wed, 05 Aug 1998 16:22:53 -0700, Glen Upreti <glen.upreti_at_nau.edu> wrote:

>I am searching for all views that reference a particular table, the
>problem is that I can not to a like since oracle stores the view text as
>a long data type and longs can not be used in where clauses. I tried to
>create a table with the idea of to_char'ing the long fields, but the
>text_length is too long for varchar2.
>I am running oracle version 7.3.3.x

Hi Glen,

the dictionary view USER_DEPENDENCIES has the information you are looking for.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Mon Aug 10 1998 - 15:33:12 CDT