Http://www.itpub.net/thread-1499223-1-1.html 1 楼 哪一个PLsql块执行之后会显示下面的三行数字? 0&nb
Http://www.itpub.net/thread-1499223-1-1.html
1 楼
哪一个PLsql块执行之后会显示下面的三行数字?
0
1
2
A
DECLARE
TYPE numbers_t IS TABLE OF NUMBER;
l_numbers numbers_t := numbers_t ();
BEGIN
DBMS_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;
/
0
1
2
B
DECLARE
TYPE numbers_t IS TABLE OF NUMBER;
l_numbers numbers_t := numbers_t ();
BEGIN
DBMS_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;
/
0
2
2
C
DECLARE
TYPE numbers_t IS TABLE OF NUMBER;
l_numbers numbers_t := numbers_t ();
BEGIN
DBMS_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;
/
0
1
1
D
DECLARE
TYPE numbers_t IS TABLE OF NUMBER;
l_numbers numbers_t := numbers_t ();
BEGIN
DBMS_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;
/
0
1
2
知识点后补
--结束END--
本文标题: 2011-10-05 COLLECTION
本文链接: https://www.lsjlt.com/news/46592.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0