--通过all_source --instr(text,'/*是否包含注释的过程*/')>0 判断text是否包含'/*是否包含注释的过程*/'已写入 file afiedt.buf 1 create or replace procedure testpro 2 as 3 /*是否包含注释的过程*/ 4 begin 5 dbms_output.put_line('hello!'); 6* end; scott@YPCOST> /过程已创建。scott@YPCOST> select text from all_source where type='PROCEDURE' and name='TESTPRO';TEXT ---------------------------------------------------------------------------------------- procedure testpro as /*是否包含注释的过程*/ begin dbms_output.put_line('hello!'); end;scott@YPCOST> ed 已写入 file afiedt.buf 1 select name from all_source 2* where type='PROCEDURE' and instr(text,'/*是否包含注释的过程*/')>0 scott@YPCOST> /NAME ------------------------------ TESTPRO
select text from all_source where type='PROCEDDURE' and name='过程名' and instr(text,'注释内容')>0
--instr(text,'/*是否包含注释的过程*/')>0 判断text是否包含'/*是否包含注释的过程*/'已写入 file afiedt.buf 1 create or replace procedure testpro
2 as
3 /*是否包含注释的过程*/
4 begin
5 dbms_output.put_line('hello!');
6* end;
scott@YPCOST> /过程已创建。scott@YPCOST> select text from all_source where type='PROCEDURE' and name='TESTPRO';TEXT
----------------------------------------------------------------------------------------
procedure testpro
as
/*是否包含注释的过程*/
begin
dbms_output.put_line('hello!');
end;scott@YPCOST> ed
已写入 file afiedt.buf 1 select name from all_source
2* where type='PROCEDURE' and instr(text,'/*是否包含注释的过程*/')>0
scott@YPCOST> /NAME
------------------------------
TESTPRO
select text from all_source where type='PROCEDDURE' and name='过程名'
and instr(text,'注释内容')>0
2、可以使用pl/sql developer工具的Tools->Find Database Object...,功能是相当地强大!