oracle底层字典表obj$及source$与存储过程procedure系列三
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott
SQL> create or replace procedure proc_non_sep
2 as
3 begin
4 null;
5 end;
6 /
Procedure created
SQL> create or replace procedure 'proc_non_sep'
2 as
3 begin
4 null;
5 end;
6 /
create or replace procedure 'proc_non_sep'
as
begin
null;
end;
ORA-04050: 过程, 函数或程序包名无效或缺失
SQL> create or replace procedure 'proc_non_sep'
/
2 /
create or replace procedure 'proc_non_sep'
ORA-04050: 过程, 函数或程序包名无效或缺失
SQL> create or replace procedure "proc_non_sep"
2 as
3 begin
4 null;
5 end;
6 /
Procedure created
SQL> create or replace procedure "proc_NON_SEP"
2 as
3 begin
4 null;
5 end;
6 /
Procedure created
SQL> select * from user_objects uo where uo.OBJECT_NAME like '%PROC_NON%';
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 19 2012-11-16:19:13:17 VALID N N N 1
SQL> select * from user_objects uo where uo.OBJECT_NAME like '%proc%';
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 132743 PROCEDURE 2012/11/16 2012/11/16 19 2012-11-16:19:14:53 VALID N N N 1
proc_non_sep 132742 PROCEDURE 2012/11/16 2012/11/16 19 2012-11-16:19:14:33 VALID N N N 1
proc_obj_new 132740 PROCEDURE 2012/11/16 2012/11/16 19 2012-11-16:19:05:16 VALID N N N 1
SQL> create or replace procedure proc_test_single
2 as
3 begin
4 null;
5 end;
6 /
Procedure created
SQL> create or replace procedure 'proc_test_single_1'
2 as
3 begin
4 null;
5 end;
6 /
create or replace procedure 'proc_test_single_1'
as
begin
null;
end;
ORA-04050: 过程, 函数或程序包名无效或缺失
SQL>
小结：
存储过程的名称不能用单引号括起来
存储过程的名称可以用双引号括起来
用双引号括起来的存储过程的大小写是区分的，即是不同的对象
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9240380/viewspace-749381/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- redhat要持续学习哟加加油
- 升级redhat 6.8 默认gdb 7.2到gdb 8.3.1操作指南
- redhat 6.8升级默认cmake 2.8到cmake 3.9
- mysql source code源代安装的前提条件requirement
- mysql handler语句之一
- mysql show open tables相关知识体系之一
- mysql snapshot read快照读及current read当前读与锁lock之一
- mysql 5.7 _rowid虚列之一
- mysql innodb lock锁之record lock之一
- mysql隐式提交事务transaction一点笔记
