PLS-9-12 Oracle PL/SQL
来源:互联网 发布:扎古2.0知乎 编辑:程序博客网 时间:2024/04/30 19:32
retreving data using select statement
v_sal emp.sal%TYPE
select ename, sal infor v_name, v_sal from emp which only stores just 1 record; it also
has a implicit cursor created by oracle
<delete from emp> also will create cursors
way to use cursor
declare open fetch open
cursor cl is select empno,ename from emp;
open cl;
loop
fetch cl into v_eno, v_name;
exit when cl%NOTFOUND;
end loop;
close cl
//this is a simplifized version
for rec in cl loop
end loop;
cursor attribute
cl%isopen
cl%found
cl%notfound
cl%rowcount
Cursors With Parameters
cursor cl (v_deptno NUMBER) IS
Oracle PL/SQL Reference Cursor
the cursor content will be determined in the beging block during the runtime
type emp_refcursor is REF CURSOR
emp_cv emp_refcurosr
PL/SQL Bulk Collect and Bulk Bind //what is the benificiency? the anwser is the performance improvement
type empnotab IS TABLE OF emp.empno%TYPE
l_EMPNO empno empnotab
curesor cl is select empno from emp
FETCH cl BULK COLLECT INTO L_EMPNO
//for x in c loop; null;end loop;
- PLS-9-12 Oracle PL/SQL
- PLS-1: Introduction to Oracle PL/SQL ended@T8
- 【Oracle 】PL/SQL重用函数调用过程中PLS-307的错误
- Oracle pl/sql 出现"PLS-00103: 出现符号""在需要下列之一时" 错误
- Oracle pl/sql 出现"PLS-00103: 出现符号""在需要下列之一时" 错误
- PLS-2--25Using Parameters in PL/SQL Procedure
- PLS-00905: 对象 SCOTT.QUERYEMPINFO 无效;PL/SQL: Statement ignored
- Oracle pl/sql编程 12---while循环
- Oracle pl/sql编程 9---if语句
- ORACLE PL/SQL 基础
- Oracle PL/SQL入门
- oracle pl/sql
- Learning Oracle PL/SQL
- ORACLE的PL/SQL
- ORACLE PL/SQL 基础
- Oracle PL/SQL入门
- ORACLE PL/SQL入门
- Oracle PL/SQL入门
- 44,数据库(06)
- JS动态添加事件
- java代码中追踪文件名和行号
- 不进位相加
- Dell OptPlex390 安装Linux
- PLS-9-12 Oracle PL/SQL
- unzip
- JavaEE EL表达式杂记(EL内置对象 EL隐式对象)
- eclipse maven plugin 插件 安装 和 配置
- Mac OSX 命令行知识
- BYTE、WORD与DWORD类型
- 五大UNIX系统家族族谱
- Mac OS X 开启和关闭显示隐藏文件
- Hibernate源码解析 Hibernate中的动态代理Javassist