OCP-051-003
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?
--以下哪个子句可以找出包含 '_D123' 字符串的行
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 '\_'
Which WHERE clause could be used in the SELECT statement to get the required output?
--以下哪个子句可以找出包含 '_D123' 字符串的行
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 '\_'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29654587/viewspace-2156038/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
OCP-051-002
下一篇：
OCP-051-004
请登录后发表评论
登录
全部评论
