Developement/DataBase
Tracing bind variable values
highheat
2008. 2. 23. 14:47
SELECT SQL_ID,
T.SQL_FULLTEXT,
B.NAME BIND_NAME,
B.VALUE_STRING BIND_STRING
FROM V$SQL T JOIN V$SQL_BIND_CAPTURE B USING (SQL_ID)
WHERE B.VALUE_STRING IS NOT NULL
AND SQL_ID = '6zr5bx6zf51w7'
ORDER BY B.NAME;