oracle 如何解决关联查询字段有保留字或关键字的问题

Question

如一个表叫TEST_TABLE 其中有个字段名是 main_id

main_id貌似和保留字MAIN冲突

SELECT main_id FROM TEST_TABLE

会报错 ORA-00904: "MAIN_ID": invalid identifier

这样加了双引查询没问题

SELECT  "main_id" FROM TEST_TABLE 

但是如果关联查询时候应该怎么写

SELECT 
A."main_id"
FROM TEST_TABLE  A
LEFT JOIN
OTHER_TABLE B
ON A."main_id"=B.other_id

这样报错

SELECT 
"A.main_id"
FROM TEST_TABLE  A
LEFT JOIN
OTHER_TABLE B
ON "A.main_id"=B.other_id

这样也报错

SELECT 
A.'main_id'
FROM TEST_TABLE  A
LEFT JOIN
OTHER_TABLE B
ON A.'main_id'=B.other_id

单引也不行

Answer 1

https://blog.csdn.net/weixin_39407700/article/details/80648269