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.
Answered Apr 14, 2017
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE %SA\_% ESCAPE ;
Answered Jan 13, 2017
Forgot your password?