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_’;
|
Download Printable PDF. VALID exam to help you PASS. |
 |
correct.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘SA\_%’ ESCAPE ‘\’;
This will work as expected
Thanks
none of the options are correct, bcoz the escape identifier is \ (backword slash). and that itself is missing.
correct.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘SA\_%’ ESCAPE ‘\’;
This will work as expected