Re: Where is v$sqltext

In article <4m8r9e$460_at_cougar.vut.edu.au>, Leng Kaing <leng_at_cougar.vut.edu.au> wrote:
>Env: Oracle 7.1.3, VMS 6.1
>
>Found something interesting: I can see v$sqltext in sql*dba when
>connected as SYS or SYSTEM. But there is no such object in sql*plus
>when connected as SYS or SYSTEM. I've searched the dictionary,
>dba_segments, dba_objects, all_segments, all_objects but can't find
>the thing. So have you got it in you 7.1.3 database? Where did it come
>from?
>
>TIA,
>Leng.

Try this:

Select * from sys.v_$sqltext;

I don't know why they use the v_$ syntax for these table names, like v_$process and v_$session.

Later...

Allen Hubenak Received on Thu May 02 1996 - 00:00:00 CEST