al Draw command
To select any specific colour,
IPSET command
for playing musical notes,
Colour statement
To alert an error,
id Screen statement
For point sets,
le Play statement
To set screen resolution,
Beep statement
To draw a straight line,
Answers
Answered by
1
Answer:
DEFINE V_DEPTNO = 20
SELECT LAST_NAME, SALARY
FROM EMPLOYEES
WHERE DEPARTMENT_ID = V_DeptNo;
A. Nothing is wrong. The query lists the employee name and
salary of the employees who belong to department 20.
B. The DEFINE statement declaration is wrong.
C. The substitution variable is not preceded with the & character.
D. The substitution variable in the WHERE clause should be V_DEPTNO instead of V_DeptNo.
----
The query will return an error, because the substitution variable is used without
an ampersand (&) character. In this query, Oracle treats V_DEPTNO as another
column name from the table and returns an error. Substitution variables are
not case sensitive.
Ans: C
Explanation:
Similar questions