Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: identify CTAS from v$ tables

Re: identify CTAS from v$ tables

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Tue, 25 Apr 2006 12:48:56 -0500
Message-ID: <de807caa0604251048k18c3a0f6i7e56870456de2a52@mail.gmail.com> 





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


--
http://www.freelists.org/webpage/oracle-l


Received on Tue Apr 25 2006 - 12:48:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US