Which SQL statement do you use here?

Question

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.

John Adney · Accepted Answer

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE %SA_% ESCAPE  ;

Which SQL statement do you use here?

+ Answer

Request

0
Follow

Share

Answer Anonymously
Answer Later

Copy Link

John Adney

John Smith

More Oracle Questions

Can You Answer

Topics Related To Oracle

Which SQL statement do you use here?

+ Answer Request 0Follow Share Answer AnonymouslyAnswer Later Copy Link

John Adney

John Smith

More Oracle Questions

Can You Answer

Topics Related To Oracle

+ Answer

Request

0
Follow

Share

Answer Anonymously
Answer Later

Copy Link