Which SQL statement do you use here? - ProProfs Discuss
Menu
SearchAsk a Question+ Ask Question
Advertisement
  1. Database
  2. Oracle

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.

Asked by Sudha_test, Last updated: Apr 06, 2024

+ Answer
Request
Share
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 

More Oracle Questions

Ask Your Own Question

Can You Answer

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

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