More info on running SQL-statements

From: <xmda_at_hotmail.com>
Date: Wed, 03 Nov 1999 14:01:36 GMT
Message-ID: <7vpf7u$rdj$1@nnrp1.deja.com>

Hi there!

I want to see the value of bind variables in sql-statements generated by the following little query I've put together:

select t.sql_text SQL,s.username,s.osuser OSUSER,sid,serial# from v$session s, v$sqltext t
where s.sql_address = t.address
and s.sql_hash_value = t.hash_value
and type = 'USER'
and status = 'ACTIVE'
and UPPER(username) like UPPER('&name') and audsid <> userenv('sessionid')
order by sid,t.address,t.hash_value,piece
/

I want to run this in SQL*Plus.

/M_at_is

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 08:01:36 CST