SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'
AND ROUTINE_TYPE='PROCEDURE'
ORDER BY ROUTINE_NAME
'Database' 카테고리의 다른 글
| 데이터모델링의 개요 (0) | 2018.08.02 |
|---|---|
| REDO, UNDO (0) | 2018.07.26 |
| 관계(Relationship) (0) | 2018.07.26 |
| Oracle Hint 종류 및 설명 (0) | 2018.07.10 |
| MSSQL Identity 설정 On/Off (0) | 2017.01.25 |