Re: Views

Hi!

Okay; I suggest two reasons that you experience this; a)If you perform the query on the views in SQLPlus it is useful to add something like:
set long 10000
set linsize 100

before performing the query on the system tables. The source code for the view is there, but SQLPlus has defaults settings that "chop off" some of the source code.

b)There still more views in the source code (the FROM clause in these views "source code"). Then you hae to dig further into the system views for those views.

If none of this suggestions describes your problem; perhaps you could supply a example of what you find, and explain what you feel is missing?

Frank

Erich <ese_at_ozemail.com.au> wrote in message news:XKQz6.1049$pO2.41497_at_ozemail.com.au...
> 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 Sun Apr 08 2001 - 07:12:19 CDT