set linesize 132 pagesize 999
column sql_fulltext format a60 word_wrap
break on sql_text skip 1
select
replace(translate(sql_fulltext,'0123456789','999999999'),'9','')
SQL_FULLTEXT
from v$sql
where sql_text like '%TEXT IDENTIFIER%'
group by replace(translate(sql_fulltext,'0123456789','999999999'),'9','')
/
从v$sql中获得sql文本的全部
最新推荐文章于 2021-04-04 22:09:01 发布