SELECT t.sql_id,
b. last_captured,
t.sql_text sql,
b.hash_value,
b.name bind_name,
b.value_string bind_value
FROM gv$sql t,
gv$sql_bind_capture b
WHERE t.sql_id =b.sql_id
AND b.value_string IS NOT NULL
AND t.sql_id ='&sql_id' --'6mz9xrh5nc007'
ORDER BY b.last_captured DESC;
No comments:
Post a Comment