You need to extract details of those products in the SALES table where the PROD_ID column contains the
string ‘_D123’. Which WHERE clause could be used in the
SELECT statement to get the required output?
A.
WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘_’
B.
WHERE prod_id LIKE ‘%\\_D123%’ ESCAPE ‘\\’
C.
WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘%_’
D.
WHERE prod_id LIKE ‘%\\_D123%’ ESCAPE ‘\\_’
Explanation:
A naturally occurring underscore character may be escaped (or treated as a regular nonspecial symbol) using
the ESCAPE identifier in conjunction with an ESCAPE character. The second example in Figure 3-12 shows
the SQL statement that retrieves the JOBS table records with JOB_ID values equal to SA_MAN and SA_REP
and which conforms to the original requirement:
select job_id from jobs
where job_id like ‘SA\\_%’ escape ‘\\’;