Number型数组declare
stmt varchar2(200);
dept_no_array dbms_sql.Number_Table;
c number;
dummy number;
begin
dept_no_array(1) := 10; dept_no_array(2) := 20;
dept_no_array(3) := 30; dept_no_array(4) := 40;
dept_no_array(5) := 30; dept_no_array(6) := 40;
stmt := 'delete from emp where deptno = :dept_array';
c := dbms_sql.open_cursor;
dbms_sql.parse(c, stmt, dbms_sql.native);
dbms_sql.bind_array(c, ':dept_array', dept_no_array, 1, 4);
dummy := dbms_sql.execute(c);
dbms_sql.close_cursor(c); exception when others then
if dbms_sql.is_open(c) then
dbms_sql.close_cursor(c);
end if;
raise;
end;
stmt varchar2(200);
dept_no_array dbms_sql.Number_Table;
c number;
dummy number;
begin
dept_no_array(1) := 10; dept_no_array(2) := 20;
dept_no_array(3) := 30; dept_no_array(4) := 40;
dept_no_array(5) := 30; dept_no_array(6) := 40;
stmt := 'delete from emp where deptno = :dept_array';
c := dbms_sql.open_cursor;
dbms_sql.parse(c, stmt, dbms_sql.native);
dbms_sql.bind_array(c, ':dept_array', dept_no_array, 1, 4);
dummy := dbms_sql.execute(c);
dbms_sql.close_cursor(c); exception when others then
if dbms_sql.is_open(c) then
dbms_sql.close_cursor(c);
end if;
raise;
end;
解决方案 »
- 这条sql语句怎么写 是高手的进来看看
- 这个语句怎么写?怎么用over(partition by)实现?
- 客户端处理package死机
- 如何从这样游标中取出值?(ORACLE)
- 对时间查询,当使用函数TRUNC时,会不会影响查询速度?
- 不得了啦~!大家帮我啊~!
- 急急急**为何我的oracle8.1.7.0.0企业版仍然无法建立分区表,请高手指教。*****
- 在oracle中在两个整型值之间执行按位逻辑与运算的运算符是什么?
- 请问,我有个表的主键能不能在插入的时候自动生成值,用户不需要填写,如果可以请问怎么写CREATE TABLE的SQL
- 天健HIS前台和后台知识
- select to_char(to_date(1234567,'j'),'Jsp') from dual;(整数转英文)
- 请问如何在ORACLE8中增加任务?
-- Define a VARRAY type.
TYPE Numbers IS VARRAY(20) OF NUMBER(3); -- Declare a NULL varray.
v_NullList Numbers; -- This varray has 2 elements.
v_List1 Numbers := Numbers(1, 2); -- This varray has one element, which itself is NULL.
v_List2 Numbers := Numbers(NULL);
BEGIN
IF v_NullList IS NULL THEN
DBMS_OUTPUT.PUT_LINE('v_NullList is NULL');
END IF; IF v_List2(1) IS NULL THEN
DBMS_OUTPUT.PUT_LINE('v_List2(1) is NULL');
END IF;
END;
VARRAY(20) OF VARCHAR2(30);
/DECLARE
-- This type is local to this block.
TYPE DateList IS VARRAY(10) OF DATE; -- We can create variables of both DateList and NameList here.
v_Dates DateList;
v_Names NameList;
BEGIN
NULL;
END;
/DECLARE
-- Since NameList is global to PL/SQL, we can reference it in
-- another block as well.
v_Names2 NameList;
BEGIN
NULL;
END;
/