|
最先答对且答案未经编辑的puber将获得纪念章一枚(答案不可编辑但可发新贴补充或纠正),其他会员如果提供有价值的分析、讨论也可获得纪念章一枚。
以往旧题索引:
http://www.itpub.net/forum.php?m ... eid&typeid=1808
原始出处:
http://www.plsqlchallenge.com/
作者:Steven Feuerstein
运行环境:SQLPLUS, SERVEROUTPUT已打开
注:本题给出答案时候要求给予简要说明才能得到奖品
哪些选项创建了一个名为PLCH_FUNC的函数,使得这个代码执行之后:
DECLARE
l_value VARCHAR2 (30) := 'This is your brain on music';
BEGIN
DBMS_OUTPUT.put_line (plch_func (l_value));
END;
/
会显示"This is your brain on music" ?
(A)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
l_return VARCHAR2 (10) := UPPER (value_in);
BEGIN
RETURN l_return;
EXCEPTION
WHEN OTHERS
THEN
RETURN value_in;
END;
/
(B)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
l_return VARCHAR2 (10);
BEGIN
l_return := UPPER (value_in);
RETURN l_return;
EXCEPTION
WHEN OTHERS
THEN
RETURN value_in;
END;
/
(C)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
BEGIN
IF LENGTH (value_in) > 10
THEN
RETURN value_in;
ELSE
RETURN UPPER (value_in);
END IF;
END;
/
(D)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
l_return VARCHAR2 (10);
PROCEDURE initialize
IS
BEGIN
l_return := UPPER (value_in);
END;
BEGIN
initialize;
RETURN l_return;
EXCEPTION
WHEN OTHERS
THEN
RETURN value_in;
END;
/
(E)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
l_return VARCHAR2 (10);
PROCEDURE initialize
IS
BEGIN
l_return := UPPER (value_in);
END;
BEGIN
RETURN l_return;
EXCEPTION
WHEN OTHERS
THEN
RETURN value_in;
END;
/
(F)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
BEGIN
DECLARE
l_return VARCHAR2 (10) := UPPER (value_in);
BEGIN
RETURN l_return;
END;
EXCEPTION
WHEN OTHERS
THEN
RETURN value_in;
END;
/
(G)
CREATE OR REPLACE FUNCTION plch_func (value_in IN VARCHAR2)
RETURN VARCHAR2
IS
BEGIN
DECLARE
l_return VARCHAR2 (10) := UPPER (value_in);
BEGIN
RETURN l_return;
EXCEPTION
WHEN OTHERS
THEN
RETURN value_in;
END;
END;
/
|
|