Re: Views

Thanks Frank,

have already discovered these dba Views, but unfortunately, for some reason they do not contain the complete query.

Regards,

Erich

Frank wrote in message
>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 - 22:15:28 CDT