Oracle Certificate Profession 1Z0-051-03

LuiseDalian發表於2014-05-08
Oracle
（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部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1156384/，如需轉載，請註明出處，否則將追究法律責任。

相關文章