如何在Oracle中转义保留字?

" "table" ) 显然需要正确的案例 _,但是,对于任何感兴趣的人,MySQL默认使用反勾号(`),除非设置为使用双引号以实现兼容性。

SELECT "MyColumn" AS "MyColAlias"
FROM "MyTable" "Alias"
WHERE "ThisCol" = 'That Value';

但是,它允许省略双引号,在这种情况下,它会悄悄地将标识符转换为大写:

SELECT MyColumn AS MyColAlias
FROM MyTable Alias
WHERE ThisCol = 'That Value';

在内部转换为:

SELECT "ALIAS" . "MYCOLUMN" AS "MYCOLALIAS"
FROM "THEUSER" . "MYTABLE" "ALIAS"
WHERE "ALIAS" . "THISCOL" = 'That Value';

select t."size" from table t 

Oracle确实使用双引号,但您很可能需要将对象名放在大写,例如“table”。默认情况下,如果创建的对象没有双引号,例如

CREATE TABLE table AS ...

TABLE

V$RESERVED_WORDS