script.sql
@@ -1,8 +1,10 @@ | |||
1 | 1 | SELECT | |
2 | + | type, | |
2 | 3 | name, | |
3 | 4 | text | |
4 | 5 | FROM | |
5 | 6 | all_source | |
6 | 7 | WHERE | |
7 | 8 | type IN ( 'FUNCTION', 'PROCEDURE' ) | |
8 | - | AND text LIKE '%DOHOD_TOVAR%' | |
9 | + | AND UPPER(text) like UPPER('%EI_KURS_VAL%') | |
10 | + | ORDER BY type, name |
上一頁
下一頁