ocp题库解析：11g-1Z0-051-第3题
来源：优技教育
ocp题库解析：11g-1Z0-051-第3题，完整题库请点击这里联系老师咨询了解
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 '\_'
Answer: B
答案解析：
ESCAPE子句为指定转译字符，因为‘_’下滑线在LIKE子句中指的是任意一个字符，所以需要把_’下滑线进行转译。
精华阅读