Which SQL statement do you use here? - ProProfs Discuss
Advertisement

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.

This question is part of oracle_test4
Asked by Sudha_test, Last updated: Oct 15, 2020

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

John Adney

John Adney

John Adney
John Adney

Answered Apr 14, 2017

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

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Jan 13, 2017

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

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

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