记录自己的学习过程,不断的更新！[@more@]

2006.07.20

-----------------------

问题：有关列名与变量名一致的情况的处理（在从 SQL SERVER 迁移到 Oracle 中处理存储过程时可能会遇到该问题）

解决：在变量名前加限定词create or replace procedure test_update(job_id varchar, my_salary int) as begin update test set min_salary = my_salary where job_id = test_update.job_id; end;

Multilevel VARRAY Example ( For Oracle )

declare
 type t1 is varray(10) of integer;
 type nt1 is varray(10) of t1; -- multilevel varray type
 va t1 := t1(2,3,5);
-- initialize multilevel varray
 nva nt1 := nt1(va, t1(55,6,73), t1(2,4), va);
 i integer;
 va1 t1;
begin
 -- multilevel access
 i := nva(2)(3); -- i will get value 73
 dbms_output.put_line(i);
 -- add a new varray element to nva
 nva.extend;

 nva(5) := t1(56, 32);
-- replace an inner varray element
 nva(4) := t1(45,43,67,43345);
-- replace an inner integer element
 nva(4)(4) := 1; -- replaces 43345 with 1
-- add a new element to the 4th varray element
-- and store integer 89 into it.
 nva(4).extend;
 nva(4)(5) := 89;
end;
/

ITPub博客

PL/SQL 学习日记

Multilevel VARRAY Example ( For Oracle )

最新文章