58. The PART_CODE column in the SPARES table contains the following list of values:
PART_CODE
A%_WQ123
A%BWQ123
AB_WQ123
Evaluate the following query:
SQL> SELECT part_code
FROM spares
WHERE part_code LIKE '%\%_WQ12%' ESCAPE '\';
Which statement is true regarding the outcome of the above query?
A. It produces an error.
B. It displays all values.
C. It displays only the values A%_WQ123 and AB_WQ123 .
D. It displays only the values A%_WQ123 and A%BWQ123 .
E. It displays only the values A%BWQ123 and AB_WQ123.
考点:转义字符
通过关键字ESCAPE 把其后面的'\' 定义成了转义字符
转义字符后面的 % 及 _ 不再表示通配符,而是分别为字符'%'与'_'
该语句中只能'%'作了转义 所以结果为 A%_WQ123 A%BWQ123
sqlplus里的默认转义字符
Answer: D
PART_CODE
A%_WQ123
A%BWQ123
AB_WQ123
Evaluate the following query:
SQL> SELECT part_code
FROM spares
WHERE part_code LIKE '%\%_WQ12%' ESCAPE '\';
Which statement is true regarding the outcome of the above query?
A. It produces an error.
B. It displays all values.
C. It displays only the values A%_WQ123 and AB_WQ123 .
D. It displays only the values A%_WQ123 and A%BWQ123 .
E. It displays only the values A%BWQ123 and AB_WQ123.
考点:转义字符
通过关键字ESCAPE 把其后面的'\' 定义成了转义字符
转义字符后面的 % 及 _ 不再表示通配符,而是分别为字符'%'与'_'
该语句中只能'%'作了转义 所以结果为 A%_WQ123 A%BWQ123
SQL> CREATE OR REPLACE VIEW spares
2 AS
3 SELECT 'PART_CODE' AS PART_CODE FROM dual UNION ALL
4 SELECT 'A%_WQ123' AS PART_CODE FROM dual UNION ALL
5 SELECT 'A%BWQ123' AS PART_CODE FROM dual UNION ALL
6 SELECT 'AB_WQ123' AS PART_CODE FROM dual;
View created
SQL> SELECT part_code
2 FROM spares
3 WHERE part_code LIKE '%\%_WQ12%' ESCAPE '\';
PART_CODE
---------
A%_WQ123
A%BWQ123
2 rows selected
SQL> SELECT part_code
2 FROM spares
3 WHERE part_code LIKE '%%_WQ12%';
PART_CODE
---------
A%_WQ123
A%BWQ123
AB_WQ123
3 rows selected
sqlplus里的默认转义字符
TEST >show escape
escape OFF
TEST >set escape on
TEST >show escape
escape "\" (hex 5c)
Answer: D