SQL> create or replace procedure proc_non_sep as

2 begin

3 null;

4 end;

5 /

Procedure created

SQL> create or replace procedure proC_non_Sep as

2 begin

3 null;

4 end;

5 /

Procedure created

SQL> select * from user_objects uo where uo.OBJECT_NAME like '%sep%';

OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME

-------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ------------------- ----------- ------------- ------------------- ------- --------- --------- --------- ---------- ------------------------------

proc_non_sep 132742 PROCEDURE 2012/11/16 2012/11/16 19 2012-11-16:19:14:33 VALID N N N 1

SQL> select * from user_objects uo where uo.OBJECT_NAME like '%SEP%';

OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME

-------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ------------------- ----------- ------------- ------------------- ------- --------- --------- --------- ---------- ------------------------------

PROC_NON_SEP 132741 PROCEDURE 2012/11/16 2012/11/16 21 2012-11-16:21:33:13 VALID N N N 1

T_LONG_SEP 132723 132723 TABLE 2012/11/13 2012/11/13 19 2012-11-13:19:40:11 VALID N N N 1

proc_NON_SEP 132743 PROCEDURE 2012/11/16 2012/11/16 19 2012-11-16:19:14:53 VALID N N N 1

小结：大小写的存储过程名字是区别的

ITPub博客

oracle底层字典表obj$及source$与存储过程procedure系列四

最新文章