select name, line || ' - ' || text code
from dba_source
where uppercase(text) like '%RAISE_APPLICATION_ERROR%'
order by name, line
line || ' - ' || text code 不能这么写吗???
from dba_source
where uppercase(text) like '%RAISE_APPLICATION_ERROR%'
order by name, line
line || ' - ' || text code 不能这么写吗???
SELECT NAME, LINE ¦ ¦ ' - ' ¦ ¦ TEXT CODE
FROM DBA_SOURCE
WHERE UPPER(TEXT) LIKE '%RAISE_APPLICATION_ERROR%'
ORDER BY NAME, LINE