get oracle_text by sql

SELECT sql_text
FROM v$sqltext a
WHERE a.hash_value = (SELECT sql_hash_value
FROM v$session b
WHERE b.SID = '&sid')
ORDER BY piece ASC
/
posted @ 2022-10-31 16:10  jack5201981  阅读(21)  评论(0)    收藏  举报