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博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-749382/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-749382/