Re: Views

From: Frank <franjoe_at_frisurf.no>
Date: Sat, 7 Apr 2001 09:44:47 +0200
Message-ID: <%zzz6.5185$R6.113874@news1.oke.nextra.no>

Hi!

If you have privileges in the remote database try to query ALL_VIEWS/USER_VIEWS/SYS.DBA_VIEWS, these have a column called TEXT, that one contains the "source code" to the view (except if the view was created by SELECT * FROM ..., then the text column will show something else). Remember that the view name is stored in uppercase.

If you haven't got privileges you have to contact a developer or DBA responsible for the remote DBA to get help.

Frank

Contact the DBA or a developer on the remote database, and ask him

Erich <ese_at_ozemail.com.au> wrote in message news:rpzz6.743$pO2.28023_at_ozemail.com.au...
> Hi everyone,
>
> I use Oracle 7.3 in conjunction with Access 97. Have tables linked to an
> Oracle database, located in another country. Some of the links are Views
> created from several tables.
>
> My question is, is there any way of examining how these views are
> constructed? The command in SQL "describe table/view" only results in
> showing the column names, without showing the table names.
>
> Help would be appreciated.
>
> Erich
>
>
Received on Sat Apr 07 2001 - 02:44:47 CDT