Which SQL statement do you use here? - ProProfs Discuss
Topics
Products
Follow Us:

Which SQL statement do you use here?
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.



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_ ;

This question is part of Oracle_test4
Asked by Sudha_test, Last updated: Mar 26, 2020

+ Answer
Request

2 Answers

John Adney

John Adney

Answered Apr 14, 2017

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE %SA\_% ESCAPE ;

 

John Smith

John Smith

Answered Jan 13, 2017

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE %SA\_% ESCAPE \ ;
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.