PL/SQL过程和函数

最新推荐文章于 2023-07-17 21:06:44 发布

原创最新推荐文章于 2023-07-17 21:06:44 发布 · 898 阅读

CC 4.0 BY-SA版权

文章标签：

#sql #object #user #database #function #oracle

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as scott
 
SQL> var job varchar2(20)
SQL> var dname varchar(20)
VARCHAR(20) unknown datatype
 
SQL> var job varchar2(20)
SQL> var dname varchar2(20)
SQL> exec :dname:=get_info('scott',:job);
 
PL/SQL procedure successfully completed
dname
---------
RESEARCH
job
---------
ANALYST
 
SQL> var r1 number
SQL> var r2 number
SQL> exec :r1:=30
 
PL/SQL procedure successfully completed
r1
---------
30
 
SQL> var r1 number
SQL> exec :r1=result(100,:30);
 
begin :r1=result(100,:30); end;
 
ORA-06550: 第 2 行, 第 10 列: 
PLS-00103: 出现符号 "="在需要下列之一时：
 := . ( @ % ; indicator
r1
---------
 
SQL> var r1 number
SQL> exec :r1=result(100,30);
 
begin :r1=result(100,30); end;
 
ORA-06550: 第 2 行, 第 10 列: 
PLS-00103: 出现符号 "="在需要下列之一时：
 := . ( @ % ; indicator
r1
---------
 
SQL> var r1 number
SQL> var r2 number
SQL> exec :r2:=30
 
PL/SQL procedure successfully completed
r2
---------
30
 
SQL> exec :r1:=result(100,:r2);
 
PL/SQL procedure successfully completed
r1
---------
3
r2
---------
10
 
SQL> col object_name format a20
SQL> select object_name,created,status from user_objects
  2  where object_type in('PROCEDURE','FUNCTION');
 
OBJECT_NAME          CREATED     STATUS
-------------------- ----------- -------
ADD_EMPLOYEE         2012/4/11 下 VALID
QUERY_EMPLOYEE       2012/4/11 下 VALID
COMPUTE              2012/4/11 下 VALID
GET_USER             2012/4/11 下 VALID
GET_SAL              2012/4/11 下 VALID
GET_INFO             2012/4/11 下 VALID
RESULT               2012/4/11 下 VALID
 
7 rows selected
 
SQL> SLECT text from user_source where name='raise_salary';
 
SLECT text from user_source where name='raise_salary'
 
ORA-00900: 无效 SQL 语句
 
SQL> select text from user_source where name='raise_salary';
 
TEXT
--------------------------------------------------------------------------------
 
SQL>