ocp認證題庫：1Z0-051-003題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp認證題庫：1Z0-051-003題：完整題庫請點擊這里聯系老師咨詢了解
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子句中指的是任意一個字符，所以需要把_’下滑線進行轉譯。
