代码改变世界

12c OCP考试专项 [1z0-071]-Q8: 关于纯数字的表名(2020.06.16)

2020-06-16 12:54  askscuti  阅读(331)  评论(0编辑  收藏  举报

You create a table named 123,which statement runs successfully?

A. SELECT * FROM "123";
B. SELECT * FROM '123';
C. SELECT * FROM '123';
D. SELECT * FROM table(123);

Answer: A

Explanation:

创建纯数字名称的表:create table "123"; 必须带双引号。
B:ORA-00903: invalid table name
C:ORA-00911: invalid character
D:ORA-22905: cannot access rows from a non-nested table item

提示:答案为个人理解和解答,难免有错,也欢迎大家及时指正。