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

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

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