1 2 Previous Next 15 Replies Latest reply: Mar 31, 2014 7:23 AM by 941949 RSS

    not working on toad


      dear all,

                i want to know what sql queries are running on database using toad,the query shown below is working for sqlplus but not

      working for toad.your help appreciated .


      sql>select a.username,a.schemaname,a.osuser,a.machine,a.program,b.sql_text from v$session a,v$sqltext b

      where a.prev_sql_id=b.sql_id

      and a.username='SCOTT'


      thanks and regards.

        1 2 Previous Next