pl/sql Daily Quiz for 13 September 2012 pl/sql challenge
Question
| by | Steven Feuerstein |
| Requires | Oracle Database 10g or later |
I create and populate a table: CREATE TABLE plch_employees
(
employee_id INTEGER,
last_name VARCHAR2 (100)
)
/
BEGIN
INSERT INTO plch_employees
VALUES (100, 'GROTHENDIECK');
INSERT INTO plch_employees
VALUES (200, 'RAMANUJAN');
INSERT INTO plch_employees
VALUES (300, 'NOETHER');
COMMIT;
END;
/Each choice completes the implementation of a procedure with this header: CREATE OR REPLACE FUNCTION plch_id ( last_name IN plch_employees.last_name%TYPE) RETURN plch_employees.employee_id%TYPE Which choice will result in the following block displaying "300" after execution? BEGIN
DBMS_OUTPUT.put_line (plch_id ('Noether'));
END;
/ |
Choices:
Choice (A) IS
last_name plch_employees.last_name%TYPE :=
UPPER (last_name);
l_return plch_employees.employee_id%TYPE;
BEGIN
SELECT EMPLOYEE_ID
INTO l_return
FROM PLCH_EMPLOYEES
WHERE LAST_NAME = last_name;
RETURN l_return;
END;
/
| |||
Choice (B) IS
l_return plch_employees.employee_id%TYPE;
BEGIN
SELECT EMPLOYEE_ID
INTO l_return
FROM PLCH_EMPLOYEES
WHERE LAST_NAME = UPPER (last_name);
RETURN l_return;
END;
/ | |||
Choice (c) IS
l_return plch_employees.employee_id%TYPE;
BEGIN
SELECT employee_id
INTO l_return
FROM plch_employees
WHERE last_name = plch_id.UPPER(last_name);
RETURN l_return;
END;
/ | |||
Choice (D) IS
l_return plch_employees.employee_id%TYPE;
BEGIN
SELECT emp.employee_id
INTO l_return
FROM plch_employees emp
WHERE emp.last_name = UPPER (plch_id.last_name);
RETURN l_return;
END;
/ | |||
Choice (E) IS
upper_name plch_employees.last_name%TYPE := UPPER (last_name);
l_return plch_employees.employee_id%TYPE;
BEGIN
SELECT employee_id
INTO l_return
FROM plch_employees
WHERE last_name = plch_id.upper_name;
RETURN l_return;
END;
/ |
本题考察了同名变量的引用及作用域，答案：D、E
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27795363/viewspace-743396/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
Insert 句法实例
请登录后发表评论
登录
全部评论
