stuzer05 zrewidował ten Gist . Przejdź do rewizji
Brak zmian
stuzer05 zrewidował ten Gist . Przejdź do rewizji
1 file changed, 3 insertions, 1 deletion
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 | |
stuzer05 zrewidował ten Gist . Przejdź do rewizji
1 file changed, 8 insertions
script.sql(stworzono plik)
| @@ -0,0 +1,8 @@ | |||
| 1 | + | SELECT | |
| 2 | + | name, | |
| 3 | + | text | |
| 4 | + | FROM | |
| 5 | + | all_source | |
| 6 | + | WHERE | |
| 7 | + | type IN ( 'FUNCTION', 'PROCEDURE' ) | |
| 8 | + | AND text LIKE '%DOHOD_TOVAR%' | |
Nowsze
Starsze