I am trying to query the sql_text column in V$SQLTEXT system table to see if a certain string exists. This string is a parameter to the stored procedure that I call. The sql_text column shows something like this:
WHERE SUB_CODE = :b1
b1 is the bind variable. The actual parameter value is 'EU'
How do I do a query to actually test to see if sql_text column has the value of the bind variable? I would like
to do something like:
WHERE UPPER(SQL_TEXT) LIKE '%EU%'
100 extra points for anyone who answers correctly within the next hour.