最先答对且答案未经编辑的puber将获得纪念章一枚(答案不可编辑但可发新贴补充或纠正)，其他会员如果提供有价值的分析、讨论也可获得纪念章一枚。
每两周的优胜者可获得itpub奖励的技术图书一本。
以往旧题索引：
http://www.itpub.net/forum.php?m ... eid&typeid=1808
原始出处：
http://www.plsqlchallenge.com/
作者：Steven Feuerstein
运行环境：SQLPLUS, SERVEROUTPUT已打开
注：本题给出答案时候要求给予简要说明才能得到奖品
我执行了这个语句:
CREATE TABLE plch_stuff
(
pky NUMBER,
nmVARCHAR2 (100)
)
/
哪些选项在执行之后会显示如下两行？
Package created.
Package Body created.
(A)
CREATE OR REPLACE PACKAGE plch_pkg
IS
SUBTYPE key_lookup_string_t IS VARCHAR2 (1000);
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN key_lookup_string_t DEFAULT NULL,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE);
END;
/
CREATE OR REPLACE PACKAGE BODY plch_pkg
IS
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN key_lookup_string_t,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE)
IS
BEGIN
NULL;
END;
END;
/
(B)
CREATE OR REPLACE PACKAGE plch_pkg
IS
SUBTYPE key_lookup_string_t IS VARCHAR2 (1000);
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN key_lookup_string_t ,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE);
END;
/
CREATE OR REPLACE PACKAGE BODY plch_pkg
IS
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN key_lookup_string_t DEFAULT NULL,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE)
IS
BEGIN
NULL;
END;
END;
/
(C)
CREATE OR REPLACE PACKAGE plch_pkg
IS
SUBTYPE key_lookup_string_t IS VARCHAR2 (1000);
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN key_lookup_string_t ,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE);
END;
/
CREATE OR REPLACE PACKAGE BODY plch_pkg
IS
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN VARCHAR2 ,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE)
IS
BEGIN
NULL;
END;
END;
/
(D)
CREATE OR REPLACE PACKAGE plch_pkg
IS
SUBTYPE key_lookup_string_t IS VARCHAR2 (1000);
PROCEDURE do_stuff (key_inIN plch_stuff.pky%TYPE,
nm_in IN plch_stuff.nm%TYPE,
misc_in IN key_lookup_string_t ,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE);
END;
/
CREATE OR REPLACE PACKAGE BODY plch_pkg
IS
PROCEDURE do_stuff (key_inIN NUMBER,
nm_in IN INTEGER,
misc_in IN key_lookup_string_t ,
date_in IN DATE DEFAULT SYSDATE,
flag_in IN BOOLEAN DEFAULT TRUE)
IS
BEGIN
NULL;
END;
END;
/
|
