Re: identify CTAS from v$ tables

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Tue, 25 Apr 2006 11:02:52 -0700 (PDT)
Message-ID: <20060425180252.43935.qmail@web402.biz.mail.mud.yahoo.com>

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_at_clfypurg> /
  no rows selected

Dennis Williams <oracledba.williams_at_gmail.com> 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  

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

Received on Tue Apr 25 2006 - 13:02:52 CDT