9 Replies Latest reply: Mar 26, 2014 2:57 AM by 941949 RSS

    no output is giving by this query


      dear all,

               i m running the query shown below but i m not getting any output,kindly help.your help will be appreciated.


      sql>select a.username,b.sql_text from v$session a,v$sqltext b

             where a.username='TEST'

             and a.sql_hash_value=b.hash_value

             and a.sql_address=b.address;


      no rows selected


      user 'TEST' is existed and it is connected to db and running queries.