DB/ORACLE

ORACLE 프로시저 특정 문자열 검색 조회

devmean 2025. 3. 27. 16:14
SELECT *
FROM USER_SOURCE
WHERE 1=1
AND TYPE = 'PROCEDURE' -- FUNCTION, TRIGGER, PROCEDURE
AND TEXT LIKE '%텍스트%' 
ORDER BY NAME, LINE
반응형