1z0-071 Oracle Database 12c SQL 第12题 &转义字符

Q12. You execute the following commands:
SQL > DEFINE hiredate = ’01-APR-2011′
SQL >SELECT employee_id, first_name, salary
FROM employees
WHERE hire_date > ‘&hiredate’
AND manager_id > &mgr_id;
For which substitution variables are you prompted for the input?
A. none, because no input required
B. both the substitution variables ”hiredate’ and ‘mgr_id’.
C. only hiredate’

D. only ‘mgr_id’

Correct Answer: D

SQL> define hiredate='01-APR-2001'
SQL> select employee_id,first_name,salary
2 from employees
3 where hire_date > '&hiredate'
4 and manager_id > &mgr_id;
old 3: where hire_date > '&hiredate' new 3: where hire_date > '01-APR-2001'
Enter value for mgr_id: 101
old 4: and manager_id > &mgr_id new 4: and manager_id > 101


EMPLOYEE_ID FIRST_NAME SALARY
----------- -------------------- - ---------
198 Donald 2600
199 Douglas 2600
202 Pat 6000