Where The Streets Have No Name

Tracing bind variable values 본문

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;