Oracle
iteye_12510
这个作者很懒,什么都没留下…
展开
-
PLSQL集合
PLSQL常见集合CREATE OR REPLACE PACKAGE BODY test AS PROCEDURE proc_01 IS --自定义记录 TYPE emp_record_type IS RECORD( name emp.ename%TYPE, sal emp.sal%TYPE, dno emp.empno%...原创 2010-09-06 02:57:27 · 84 阅读 · 0 评论 -
Oracle批量绑定
PROCEDURE proc_02 IS /*create table demo (id number(6) primary key , name varchar2(10));*/ TYPE id_table_type IS TABLE OF NUMBER(6) INDEX BY BINARY_INTEGER; TYPE name_tabl...原创 2010-09-06 22:37:08 · 183 阅读 · 0 评论 -
游标简介
DECLARE CURSOR cur(no NUMBER) IS SELECT ename FROM emp WHERE deptno = no; v_name emp.ename%TYPE; --集合 TYPE name_table_type IS TABLE OF emp.ename%TYPE INDEX BY BINARY_INTEGER; na...原创 2010-09-06 22:57:50 · 87 阅读 · 0 评论