http://www.itpub.net/thread-1499223-1-1.html

1楼


哪一个PLSQL块执行之后会显示下面的三行数字？

0

1

2


A

DECLARETYPEnumbers_tISTABLEOFNUMBER;l_numbersnumbers_t:=numbers_t();BEGINDBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers.EXTEND();l_numbers(1):=100;DBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers.EXTEND();DBMS_OUTPUT.put_line(l_numbers.COUNT);END;/

012

B

DECLARETYPEnumbers_tISTABLEOFNUMBER;l_numbersnumbers_t:=numbers_t();BEGINDBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers.EXTEND(2);l_numbers(1):=100;DBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers(2):=100;DBMS_OUTPUT.put_line(l_numbers.COUNT);END;/

022

C

DECLARETYPEnumbers_tISTABLEOFNUMBER;l_numbersnumbers_t:=numbers_t();BEGINDBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers.EXTEND(2);l_numbers(1):=100;l_numbers.DELETE(1);DBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers(2):=100;DBMS_OUTPUT.put_line(l_numbers.COUNT);END;/

011

D

DECLARETYPEnumbers_tISTABLEOFNUMBER;l_numbersnumbers_t:=numbers_t();BEGINDBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers.EXTEND(2);l_numbers(1):=100;l_numbers.DELETE(1);DBMS_OUTPUT.put_line(l_numbers.COUNT);l_numbers(1):=200;l_numbers(2):=100;DBMS_OUTPUT.put_line(l_numbers.COUNT);END;/

012


知识点后补