Re: identify CTAS from v$ tables
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: joseph@xxxxxxxxxxxxxx
- Date: Tue, 25 Apr 2006 12:48:56 -0500
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: