（3）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 '\_'

答案：（B）

ITPub博客

Oracle Certificate Profession 1Z0-051-03

最新文章