150樓
郫都網站建設公司成都創(chuàng)新互聯(lián)公司,郫都網站設計制作,有大型網站制作公司豐富經驗。已為郫都上千余家提供企業(yè)網站建設服務。企業(yè)網站搭建\外貿營銷網站建設要多少錢,請找那個售后服務好的郫都做網站的公司定做!我連接到HR用戶并運行了如下語句:
CREATE TABLE plch_parts ( partnum NUMBER , partname VARCHAR2 (50) ) / BEGIN INSERT INTO plch_parts VALUES (1, 'Chassis'); COMMIT; END; / CREATE OR REPLACE PACKAGE plch_pkg IS TYPE parts_t IS TABLE OF plch_parts%ROWTYPE INDEX BY PLS_INTEGER; PROCEDURE plch_show_parts (parts_in IN parts_t); END; / CREATE OR REPLACE PACKAGE BODY plch_pkg IS PROCEDURE plch_show_parts (parts_in IN parts_t) IS BEGIN FOR indx IN 1 .. parts_in.COUNT LOOP DBMS_OUTPUT.put_line (parts_in (indx).partname); END LOOP; END; END; / GRANT SELECT ON plch_parts TO scott / GRANT EXECUTE ON plch_pkg TO scott /
然后我又用SCOTT用戶連接并創(chuàng)建了這張表:
CREATE TABLE plch_parts ( partnum NUMBER , partname VARCHAR2 (50) ) / BEGIN INSERT INTO plch_parts VALUES (100, 'Wheel'); COMMIT; END; /
下列的哪些選項包含了下列語句塊的一個聲明部分,從而使得這個塊執(zhí)行之后"Wheel"會被顯示出來?
BEGIN SELECT * BULK COLLECT INTO l_parts FROM plch_parts; hr.plch_pkg.plch_show_parts (l_parts); END;
(A)
DECLARE TYPE parts_t IS TABLE OF plch_parts%ROWTYPE INDEX BY PLS_INTEGER; l_parts parts_t;
SQL> DECLARE 2 TYPE parts_t IS TABLE OF plch_parts%ROWTYPE INDEX BY PLS_INTEGER; 3 4 l_parts parts_t; 5 6 BEGIN 7 SELECT * BULK COLLECT INTO l_parts FROM plch_parts; 8 9 yoga.plch_pkg.plch_show_parts(l_parts); 10 END; 11 / DECLARE TYPE parts_t IS TABLE OF plch_parts%ROWTYPE INDEX BY PLS_INTEGER; l_parts parts_t; BEGIN SELECT * BULK COLLECT INTO l_parts FROM plch_parts; yoga.plch_pkg.plch_show_parts(l_parts); END; ORA-06550: 第 9 行, 第 3 列: PLS-00306: 調用 'PLCH_SHOW_PARTS' 時參數個數或類型錯誤 ORA-06550: 第 9 行, 第 3 列: PL/SQL: Statement ignored SQL>
(B)
DECLARE TYPE parts_t IS TABLE OF hr.plch_parts%ROWTYPE INDEX BY PLS_INTEGER; l_parts parts_t;
SQL> DECLARE 2 TYPE parts_t IS TABLE OF yoga.plch_parts%ROWTYPE INDEX BY PLS_INTEGER; 3 4 l_parts parts_t; 5 6 BEGIN 7 SELECT * BULK COLLECT INTO l_parts FROM plch_parts; 8 9 yoga.plch_pkg.plch_show_parts(l_parts); 10 END; 11 / DECLARE TYPE parts_t IS TABLE OF yoga.plch_parts%ROWTYPE INDEX BY PLS_INTEGER; l_parts parts_t; BEGIN SELECT * BULK COLLECT INTO l_parts FROM plch_parts; yoga.plch_pkg.plch_show_parts(l_parts); END; ORA-06550: 第 9 行, 第 3 列: PLS-00306: 調用 'PLCH_SHOW_PARTS' 時參數個數或類型錯誤 ORA-06550: 第 9 行, 第 3 列: PL/SQL: Statement ignored SQL>
(C)
DECLARE l_parts hr.plch_pkg.parts_t;
SQL> DECLARE 2 l_parts yoga.plch_pkg.parts_t; 3 4 BEGIN 5 SELECT * BULK COLLECT INTO l_parts FROM plch_parts; 6 7 yoga.plch_pkg.plch_show_parts(l_parts); 8 END; 9 / Wheel PL/SQL procedure successfully completed SQL>
(D)
DECLARE SUBTYPE parts_t IS hr.plch_pkg.parts_t; l_parts parts_t;
SQL> DECLARE 2 SUBTYPE parts_t IS yoga.plch_pkg.parts_t; 3 l_parts parts_t; 4 5 BEGIN 6 SELECT * BULK COLLECT INTO l_parts FROM plch_parts; 7 8 yoga.plch_pkg.plch_show_parts(l_parts); 9 END; 10 / Wheel PL/SQL procedure successfully completed SQL>
實測用yoga代替hr,test代替scott
答案在158樓
2011-11-16 答案CD.
%ROWTYPE是一種記錄,如果你定義兩個結構一模一樣的記錄類型,它們仍然不能夠互換,會報類型不匹配的錯誤。
網站標題:ROWTYPE的聲明與使用-創(chuàng)新互聯(lián)
網頁路徑:http://www.muchs.cn/article2/dsscoc.html
成都網站建設公司_創(chuàng)新互聯(lián),為您提供面包屑導航、Google、App開發(fā)、App設計、自適應網站、網站設計
聲明:本網站發(fā)布的內容(圖片、視頻和文字)以用戶投稿、用戶轉載內容為主,如果涉及侵權請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內容未經允許不得轉載,或轉載時需注明來源: 創(chuàng)新互聯(lián)