1z0-071 Oracle Database 12c SQL 第39题 single quotation mark单引号

最新推荐文章于 2021-04-16 09:16:54 发布

城风漫漫

最新推荐文章于 2021-04-16 09:16:54 发布

阅读量917

点赞数

分类专栏：数据库：Oracle DBA成长之路文章标签： 1z0-071 ocp oracle 11g oracle 12c

数据库：Oracle DBA成长之路专栏收录该内容

165 篇文章

订阅专栏

本文探讨了在执行特定SQL查询时遇到的ORA-01756错误：字符串未正确终止。通过分析错误原因及提供正确的解决方案，帮助读者了解如何使用Quote(q)操作符和界定符来允许在字符字符串中使用单引号。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Q39. Evaluate the following SQL statement:
SELECT product_name || ‘it’s not available for order’
FROM product_information
WHERE product_status = ‘obsolete’;
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?
A. Enclose the literal character string in the SELECT clause within the double quotation marks.
B. Do not enclose the character literal string in the SELECT clause within the single quotation marks.
C. Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.

D. Use escape character to negate the single quotation mark inside the literal character string in the SELECT clause.

Correct Answer: C
Explanation/Reference:
References:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm