±±´óÇàÄñoracleѧϰ±Ê¼Ç31

pl/sql ±í
ÔÚpl/sql¿éÖÐÁÙʱʹÓá¢ÏñÊý×éÒ»ÑùµÄ¶ÔÏó
°üº¬Ò»ÁкÍÒ»¸öÖ÷¼ü
²»ÄܶÔÁкÍÖ÷¼ü½øÐÐÃüÃû
ÁпÉÒÔÊÇÈκαêÁ¿Êý¾ÝÀàÐÍ
Ö÷¼ü±ØÐëÊÇbinary_integerÀàÐÍ
´óСûÓÐÏÞÖÆ
ÉùÃ÷pl/sql±í
    ¶¨Òå±íµÄÀàÐÍ
    type ÀàÐÍÃû is table of ÁÐÀàÐÍ|±äÁ¿Êý¾ÝÀàÐÍ index by binary_integer;
    ÉùÃ÷±í±äÁ¿
    ±íÃû ÀàÐÍÃû;
ÒýÓÃpl/sql±í
    ±íÃû(ϱê)
¸³Öµ
    ±íÃû(ϱê):=±í´ïʽ;
ÊôÐÔ·½·¨:
   count --·µ»Øpl/sql±íµÄ×ÜÐÐÊý£»
   delect --ɾ³ýpl/sql±íµÄËùÓÐÄÚÈÝ£»
   delect(ÐÐÊý) --ɾ³ýpl/sql±íµÄÖ¸¶¨µÄÐУ»
   delct(¿ªÊ¼ÐУ¬½áÊøÐÐ) --ɾ³ýpl/sql±íµÄ¶àÐУ»
   first --·µ»Ø±íµÄµÚÒ»¸öINDEX;
   next(ÐÐÊý) --Õâ¸öÐÐÊýµÄÏÂÒ»ÌõµÄINDEX;
   last --·µ»Ø±íµÄ×îºóÒ»¸öINDEX;
declare
Type stuNameTableType is table of student.stu_name%type index by binary_integer;
stuNameTable stuNameTableType;
begin
for i in 1..10
loop
stunametable(i):='student'||i;
end loop;

for i in 1..stunametable.count
loop
dbms_output.put_line('µÚ'||i||'¸öÔªËØ£º'||stunametable(i));
end loop;
end;
±íÀàÐÍÐèҪʹÓÃbulk collectÅúÁ¿°ó¶¨½øÐÐselect¸³Öµ£¬bulk collect×Ó¾äÒ²¿ÉÓÃÓÚFetch bulk collect into ×Ó¾äÖÐ
declare
TYPE studentTableType is table of student%rowtype index by binary_integer;
studentTable studentTableType;
begin
select * bulk collect into studentTable from student order by stu_id;
for i in 1..studentTable.count loop
dbms_output.put_line(studentTable(i).stu_id);
dbms_output.put_line(studentTable(i).stu_name);
dbms_output.put_line(studentTable(i).stu_sex);
dbms_output.put_line(studentTable(i).stu_birthday);
end loop;
end;
RecordÀàÐÍ
ÉùÃ÷

    type ¼Ç¼ÀàÐÍÃû is record (

        ×Ö¶Î1 ÀàÐÍ[not null[:=±í´ïʽ]]

        ×Ö¶În ÀàÐ