The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain ‘SA_’ in the JOB_ID column. Which SQL statement do you use?
A.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\\_’ ESCAPE ‘\\’;
B.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_’;
C.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_’ ESCAPE “\\”;
D.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id = ‘%SA_’;
Explanation:
ESCAPE identifier to search for the _ symbol
Incorrect answer:
B:
ESCAPE identifier must be use
C:
wrong syntax
D:
wrong syntax
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-13