[oracle@ucjmh ~]$ sqlplus \/ as sysdba<\/p>\n
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 7 09:01:40 2015<\/p>\n
Copyright (c) 1982, 2011, Oracle. All rights reserved.<\/p>\n
Connected to:<\/p>\n
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 \u2013 Production<\/p>\n
With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/p>\n
SQL> set serveroutput on<\/p>\n
SQL> DECLARE<\/p>\n
\u2014 declare fixed array<\/p>\n
TYPE arry_num IS VARRAY(10) OF NUMBER;<\/p>\n
arry_top arry_num;<\/p>\n
v_n int;<\/p>\n
BEGIN<\/p>\n
\u2014 init array<\/p>\n
arry_top := arry_num(1,2,3);<\/p>\n
dbms_output.put_line(arry_top.LIMIT());<\/p>\n
dbms_output.put_line(arry_top.count());<\/p>\n
dbms_output.put_line(arry_top.FIRST());<\/p>\n
\u2013dbms_output.put_line(arry_top.NEXT());<\/p>\n
\u2014 dbms_output.put_line(arry_top.PRIOR());<\/p>\n
dbms_output.put_line(arry_top.LAST());<\/p>\n
dbms_output.put_line(arry_top(2));<\/p>\n
FOR I IN 1..arry_top.COUNT() LOOP<\/p>\n
v_n:=arry_top(I);<\/p>\n
dbms_output.put_line(v_n);<\/p>\n
DBMS_OUTPUT.PUT_LINE(\u2018arry_top(\u2018||I||\u2019)=\u2019 || arry_top(I));<\/p>\n
END LOOP;<\/p>\n
END;<\/p>\n
\/<\/p>\n
10<\/p>\n
3<\/p>\n
1<\/p>\n
3<\/p>\n
2<\/p>\n
1<\/p>\n
arry_top(1)=1<\/p>\n
2<\/p>\n
arry_top(2)=2<\/p>\n
3<\/p>\n
arry_top(3)=3<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
SQL><\/p>\n
\u58f0\u660e\u548c\u521d\u59cb\u5316VARRAY\u53d8\u91cf<\/p>\n
\u4f60\u4e0d\u53ef\u4ee5\u76f4\u63a5\u58f0\u660e\u4e00\u4e2aVARRAY\u53d8\u91cf\u3002\u5fc5\u987b\u5148\u58f0\u660e\u4e00\u4e2a\u5305\u542b\u8fd9\u4e2a\u6570\u7ec4\u6700\u5927\u5bb9\u91cf\u7684\u7c7b\u578b\uff1a
\n1. TYPE MY_ARRAY_TYPE IS VARRAY(10) OF NUMBER;
\n\u7136\u540e\uff0c\u4f60\u5c31\u53ef\u4ee5\u7528\u8fd9\u4e2a\u7c7b\u578b\u58f0\u660eVARRAY\u53d8\u91cf\uff1a
\n1. V MY_ARRAY_TYPE;
\n\u5728\u4f60\u5bf9\u8fd9\u4e2a\u6570\u7ec4\u8fdb\u884c\u64cd\u4f5c\u4ee5\u524d\uff0c\u5fc5\u987b\u5148\u521d\u59cb\u5316\u8be5\u6570\u7ec4\u3002\u4f60\u65e2\u53ef\u4ee5\u5728\u58f0\u660e\u5b83\u7684\u65f6\u5019\u5bf9\u5176\u521d\u59cb\u5316\uff0c\u4e5f\u53ef\u4ee5\u5728\u58f0\u660e\u540e\u5bf9\u5176\u8d4b\u503c\u3002\u4e0b\u9762\u5c55\u793a\u4e86\u5728\u58f0\u660e\u7684\u540c\u65f6\u5bf9\u5176\u8fdb\u884c\u521d\u59cb\u5316\uff1a
\n1. V MY_ARRAY_TYPE := MY_ARRAY_TYPE ();
\n\u4ece\u6307\u5b9a\u7684\u6761\u76ee\u5904\u53d6\u503c<\/p>\n
\u628a\u6761\u76ee\u7684\u6570\u76ee\u4f5c\u4e3a\u4e0b\u6807\u3002\u4e0b\u6807\u53ef\u4ee5\u662f\u8fd4\u56de\u6574\u6570\u503c(\u8be5\u503c\u5c0f\u4e8e\u6216\u7b49\u4e8e\u6570\u7ec4\u6761\u76ee\u6570)\u7684\u4efb\u610f\u8868\u8fbe\u5f0f\uff0c\u5982\uff1a
\n1. K := V(3); 2. I := 2; 3. L := V(I+1);
\n\u5f97\u5230\u6570\u7ec4\u7684\u5bb9\u91cf<\/p>\n
\u5bf9VARRAY\u53d8\u91cf\u4f7f\u7528COUNT()\u65b9\u6cd5\u3002\u6ce8\u610f\uff0c\u4f60\u4e0d\u9700\u8981\u6307\u5b9a\u5706\u62ec\u53f7\uff0c\u56e0\u4e3a\u8fd9\u4e2a\u65b9\u6cd5\u6ca1\u6709\u8f93\u5165\u53c2\u6570\uff1a
\n1. N_ENTRIES := V.COUNT();
\n\u8fd9\u544a\u8bc9\u4f60\u8fd9\u4e2a\u6570\u7ec4\u4e2d\u6b63\u5728\u4f7f\u7528\u7684\u6761\u76ee\u6570\u3002\u5f53VARRAY\u7c7b\u578b\u88ab\u58f0\u660e\u7684\u65f6\u5019\uff0c\u5176\u6700\u5927\u7684\u5bb9\u91cf\u4e5f\u5c31\u88ab\u5b9a\u4e49\u4e86\u3002\u4f60\u53ef\u4ee5\u7528LIMIT()\u65b9\u6cd5\u5f97\u5230\u8be5\u5bb9\u91cf\uff1a
\n1. ARRAY_CAPACITY := V.LIMIT();
\n\u904d\u5386VARRAY\u4e2d\u7684\u503c<\/p>\n
\u4f60\u53ef\u4ee5\u4f7f\u7528\u591a\u79cd\u6280\u672f\u3002\u6700\u7b80\u5355\u7684\u662f\u4f7f\u7528FOR\u5faa\u73af\uff1a
\n1. FOR I IN 1..V.COUNT() LOOP 2. DBMS_OUTPUT.PUT_LINE(\u2018V(\u2018||I||\u2019)=\u2019 || V(I)); 3. END LOOP;
\n\u4f60\u4e5f\u53ef\u4ee5\u4f7f\u7528FIRST()\u548cLAST()\u65b9\u6cd5\u3002FIRST()\u8fd4\u56de\u6570\u7ec4\u7684\u7b2c\u4e00\u4e2a\u6761\u76ee\u7684\u4e0b\u6807(\u603b\u662f1)\uff0cLAST()\u8fd4\u56de\u6570\u7ec4\u7684\u6700\u540e\u4e00\u4e2a\u6761\u76ee\u7684\u4e0b\u6807(\u4e0eCOUNT\u65b9\u6cd5\u76f8\u540c)\u3002
\n1. FOR I IN V.FIRST()..V.LAST() LOOP 2. DBMS_OUTPUT.PUT_LINE(\u2018V(\u2018||I||\u2019)=\u2019 || V(I)); 3. END LOOP;
\n\u4f60\u4e5f\u53ef\u4ee5\u4f7f\u7528PRIOR(n)\u548cNEXT(n)\u65b9\u6cd5\uff0c\u8fd9\u4e24\u4e2a\u65b9\u6cd5\u5206\u522b\u8fd4\u56de\u7ed9\u5b9a\u6761\u76ee\u7684\u524d\u4e00\u4e2a\u548c\u540e\u4e00\u4e2a\u6761\u76ee\u7684\u4e0b\u6807\u3002\u4f8b\u5982\uff0c\u4e0b\u9762\u7684\u4ee3\u7801\u7528\u6765\u5411\u540e\u904d\u5386\u6574\u4e2a\u6570\u7ec4\uff1a
\n1. I := V.COUNT(); 2. WHILE I IS NOT NULL LOOP 3. DBMS_OUTPUT.PUT_LINE(\u2018V(\u2018||I||\u2019)=\u2019 || V(I)); 4. I := V.PRIOR(I); 5. END LOOP;
\nPRIOR(n)\u548cn-1\u662f\u4e00\u6837\u7684\uff0cNEXT(n)\u548cn+1\u662f\u4e00\u6837\u7684\uff0c\u4f46\u662fPRIOR(1)\u548cNEXT(V.COUNT())\u5219\u8fd4\u56deNULL\u3002
\n\u5bf9VARRAY\u7684\u6269\u5c55<\/p>\n
\u4f7f\u7528EXTEND(k)\u65b9\u6cd5\u3002\u8fd9\u4e2a\u65b9\u6cd5\u53ef\u4ee5\u5728VARRAY\u7684\u6700\u540e\u8ffd\u52a0k\u4e2a\u65b0\u7684\u6761\u76ee\u3002\u5982\u679ck\u6ca1\u6709\u88ab\u6307\u5b9a\uff0c\u53ea\u589e\u52a0\u4e00\u4e2a\u6761\u76ee\u3002\u65b0\u589e\u7684\u6761\u76ee\u6ca1\u6709\u503c(\u9ed8\u8ba4\u4e3aNULL)\uff0c\u4f46\u662f\u4f60\u53ef\u4ee5\u5bf9\u5b83\u4eec\u8fdb\u884c\u521d\u59cb\u5316\u3002COUNT()\u548cLAST()\u65b9\u6cd5\u73b0\u5728\u53ef\u4ee5\u53cd\u6620VARRAY\u65b0\u7684\u5bb9\u91cf\u3002\u4ee5\u4e0b\u4ee3\u7801\u5411\u6570\u7ec4\u4e2d\u6dfb\u52a0\u4e24\u4e2a\u6761\u76ee\u5e76\u5bf9\u5176\u8fdb\u884c\u521d\u59cb\u5316\uff1a
\n1. I := V.LAST(); 2. V.EXTEND(2); 3. V(I+1) := 5; 4. V(I+2) := 6;
\n\u6ce8\u610f\uff0c\u4f60\u5bf9VARRAY\u7684\u6269\u5c55\u4e0d\u53ef\u4ee5\u8d85\u8fc7\u5176\u6700\u5927\u5bb9\u91cf(\u901a\u8fc7LIMIT()\u65b9\u6cd5\u5f97\u5230)\uff0c\u4e14\u5728\u5bf9VARRAY\u6269\u5c55\u524d\u5fc5\u987b\u8981\u5bf9\u5176\u8fdb\u884c\u521d\u59cb\u5316\u3002\u4ee5\u4e0b\u4ee3\u7801\u662f\u65e0\u6548\u7684\uff1a
\n1. VT MY_ARRAY_TYPE; 2. VT.EXTEND(5);
\n\u4e0b\u9762\u7684\u4ee3\u7801\u662f\u6709\u6548\u7684\uff1a
\n1. VT MY_ARRAY_TYPE; 2. VT := MY_ARRAY_TYPE(); 3. VT.EXTEND(5);
\n\u5bf9VARRAY\u7684\u7f29\u51cf<\/p>\n
\u4f7f\u7528TRIM(k)\u65b9\u6cd5\u3002\u8fd9\u4e2a\u65b9\u6cd5\u5728VARRAY\u7684\u5c3e\u90e8\u5220\u9664\u6700\u540ek\u4e2a\u6761\u76ee\u3002\u5f53k\u6ca1\u6709\u88ab\u6307\u5b9a\u65f6\uff0c\u5220\u9664\u6700\u540e\u4e00\u4e2a\u6761\u76ee\u3002\u5df2\u88ab\u5220\u9664\u7684\u6761\u76ee\u7684\u503c\u5c06\u4e22\u5931\u3002COUNT()\u548cLAST()\u65b9\u6cd5\u53cd\u6620\u4e86\u65b0\u7684\u5bb9\u91cf\u3002\u4e0b\u9762\u4eceVARRAY\u4e2d\u5220\u9664\u6700\u540e\u4e00\u4e2a\u6761\u76ee\uff1a
\n1. V.TRIM;
\n\u4f60\u4e5f\u53ef\u4ee5\u7528\u4ee5\u4e0b\u65b9\u5f0f\u5220\u9664\u6570\u7ec4\u4e2d\u7684\u6240\u6709\u6761\u76ee\uff1a
\n1. V.TRIM(V.COUNT());
\n\u6216\u8005\u7528\u5177\u6709\u6548\u679c\u76f8\u540c\u7684DELETE()\u65b9\u6cd5\u3002\u8be5\u65b9\u6cd5\u5220\u9664\u6570\u7ec4\u4e2d\u7684\u6240\u6709\u6761\u76ee\uff0c\u5e76\u628a\u5176\u5bb9\u91cf\u8bbe\u7f6e\u4e3a0(\u4e5f\u5c31\u662f\u8bf4\uff0cV.COUNT()\u73b0\u5728\u7684\u8fd4\u56de\u503c\u4e3a0)\u3002
\n1. V.DELETE()<\/p>\n","protected":false},"excerpt":{"rendered":"
[oracle@ucjmh ~]$ sqlplus \/ as sysdba SQL*Plus: Release […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34,2],"class_list":["post-588","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-oracle_basics"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=588"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/588\/revisions"}],"predecessor-version":[{"id":892,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/588\/revisions\/892"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=588"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}