select DISTINCT TYPE from dba_source where wner='DFMS' ;
类型有: 'PROCEDURE','FUNCTION','PACKAGE','PACKAGE BODY' , 'Trigger'
select NAME, LINE, TEXT from dba_source where type IN ('PROCEDURE','FUNCTION','PACKAGE','PACKAGE BODY') and wner='DFMS' AND TEXT LIKE '%check_close_flag%' ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-619680/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-619680/