Re: identify CTAS from v$ tables
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: Dennis Williams <oracledba.williams@xxxxxxxxx>
- Date: Tue, 25 Apr 2006 11:02:52 -0700 (PDT)
Still no luck
1 select sid, sql_text
2 from v$session a, v$sql b
3 where a.sql_address = b.address
4* and command = 1
sys@clfypurg> /
no rows selected
Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:
Joseph,
How about:
select sid, sql_text
from v$session a, v$sql b
where a.sql_address = b.address
and command = 1
Dennis Williams
Other related posts:
