script.sql
· 169 B · MySQL
原始檔案
SELECT
type,
name,
text
FROM
all_source
WHERE
type IN ( 'FUNCTION', 'PROCEDURE' )
AND UPPER(text) like UPPER('%EI_KURS_VAL%')
ORDER BY type, name
| 1 | SELECT |
| 2 | type, |
| 3 | name, |
| 4 | text |
| 5 | FROM |
| 6 | all_source |
| 7 | WHERE |
| 8 | type IN ( 'FUNCTION', 'PROCEDURE' ) |
| 9 | AND UPPER(text) like UPPER('%EI_KURS_VAL%') |
| 10 | ORDER BY type, name |