您好,登錄后才能下訂單哦!
http://www.itpub.net/thread-1499223-10-1.html
93樓
我創(chuàng)建了這張表并填入數(shù)據(jù):
CREATE TABLE plch_new_parts ( partnum NUMBER , partname VARCHAR2 (50) ) / BEGIN INSERT INTO plch_new_parts (partnum, partname) VALUES (1, 'MY PART NUMBER 1'); INSERT INTO plch_new_parts (partnum, partname) VALUES (2, 'MY_PART_NUMBER_2'); INSERT INTO plch_new_parts (partnum, partname) VALUES (3, 'MY_PART NUMBER_3'); COMMIT; END; /
當(dāng)我執(zhí)行下列這段代碼,屏幕上會(huì)顯示什么?
DECLARE l_counts DBMS_SQL.number_table; BEGIN l_counts (1) := 0; l_counts (2) := 0; l_counts (3) := 0; l_counts (4) := 0; FOR rec IN ( SELECT partname FROM plch_new_parts ORDER BY partnum) LOOP IF rec.partname LIKE 'MY PART NUMBER %' THEN l_counts (1) := l_counts (1) + 1; END IF; IF rec.partname LIKE 'MY_PART_NUMBER_%' THEN l_counts (2) := l_counts (2) + 1; END IF; IF rec.partname LIKE 'MY_PART NUMBER_%' THEN l_counts (3) := l_counts (3) + 1; END IF; IF rec.partname LIKE 'MY?PART?NUMBER?*' THEN l_counts (4) := l_counts (4) + 1; END IF; END LOOP; FOR indx IN 1 .. l_counts.COUNT LOOP DBMS_OUTPUT.put_line (l_counts (indx)); END LOOP; END; /
(A)
1 1 1 0
(B)
1 3 2 0
(C)
0 0 0 3
(D)
3 3 3 3
(E)
1 3 2 3
運(yùn)行結(jié)果如下
SQL> DECLARE 2 l_counts DBMS_SQL.number_table; 3 4 BEGIN 5 l_counts (1) := 0; 6 l_counts (2) := 0; 7 l_counts (3) := 0; 8 l_counts (4) := 0; 9 10 FOR rec IN ( SELECT partname 11 FROM plch_new_parts 12 ORDER BY partnum) 13 LOOP 14 IF rec.partname LIKE 'MY PART NUMBER %' 15 THEN 16 l_counts (1) := l_counts (1) + 1; 17 END IF; 18 19 IF rec.partname LIKE 'MY_PART_NUMBER_%' 20 THEN 21 l_counts (2) := l_counts (2) + 1; 22 END IF; 23 24 IF rec.partname LIKE 'MY_PART NUMBER_%' 25 THEN 26 l_counts (3) := l_counts (3) + 1; 27 END IF; 28 29 IF rec.partname LIKE 'MY?PART?NUMBER?*' 30 THEN 31 l_counts (4) := l_counts (4) + 1; 32 END IF; 33 END LOOP; 34 35 FOR indx IN 1 .. l_counts.COUNT 36 LOOP 37 DBMS_OUTPUT.put_line (l_counts (indx)); 38 END LOOP; 39 END; 40 / 1 3 2 PL/SQL procedure successfully completed SQL>
答案B
答案說明96樓
2011-10-28答案B. _匹配單個(gè)字符,%匹配任意個(gè)字符,*和?是忽悠人的。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。