- 博客(9)
- 收藏
- 关注
原创 游标在fetch过程中不允许更新自己
SQL> Declare 2 vname dept.dname%Type; 3 Begin 4 For csr In(Select * From dept For Update) Loop 5 Update dept Set dname=Upper(dname) Where deptno=csr.deptno Returning dname In
2015-11-30 01:32:44 449
原创 Continue
SQL> Declare 2 i Number; 3 Begin 4 > 5 For i In 1..10 Loop 6 Continue Outer When Mod(i,2)=0; 7 Exit Outer When i>6; 8 dbms_output.put_line(i); 9 End
2015-11-30 00:07:05 231
原创 sql%rowcount
1、没有执行过select、insert、update、delete sql%rowcount为null2、commit、rollback后 sql%rowcount为0SQL> Declare 2 Type t Is Table Of dept%Rowtype; 3 vt t; 4 Begin 5 If Sql%Rowcount Is Nul
2015-11-29 23:34:25 958
原创 case语句(未找到Case)
SQL> Declare 2 i Varchar2(20); 3 Begin 4 i:=Case 3 5 When 1 Then 1.1 6 When 2 Then 1.2 7 End; 8 If i Is Null Then 9 dbms_output.put_line(
2015-11-28 01:53:05 2950
原创 table(集合对象)
说明:table()必须使用schema级别的集合对象SQL> Declare 2 Type t_nstbl Is Table Of Varchar2(20); --本地 3 v_nstbl t_nstbl; 4 csr Sys_Refcursor; 5 vlu Varchar2(20); 6 Begin 7 v_nstbl
2015-11-28 01:51:09 388
原创 DML语句的Returning...Into...
SQL> Declare 2 vID Number; 3 vNM Varchar2(20); 4 Type t_stu Is Table Of stu%Rowtype; 5 v_stu t_stu; 6 i Number; 7 Begin 8 dbms_output.put_line('*******insert***
2015-11-26 00:28:42 337
原创 bulk collect
SQL> set serverout onSQL> SQL> Declare 2 Cursor Csr Is Select Level From dual Connect By Level 3 Type T_Csr Is Table Of Varchar2(10); 4 v_Csr T_Csr; 5 i Number:=0; 6
2015-11-25 23:46:06 403
原创 <<Label_Name>>End Loop Label_Name;
语法: [>] Loop Continue [Label_Name] .... Exit [Label_Name]... --statement End Loop [Label_Name]; [>] For ... Loop Continue [Label_Name] .... Ex
2015-11-25 02:10:51 347
原创 SYS_REFCURSOR
1、使用SYS_REFCURSORSQL> Declare 2 Cur Sys_Refcursor; 3 R scott.dept%Rowtype; 4 Begin 5 Open Cur For Select * From scott.dept; 6 Loop 7 Fetch Cur Into R; 8
2015-11-24 00:26:16 762
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人