ORACLE中,如果表中的字段名,正好跟sql中关键词重名,写sql语句时:
1.要将该字段名大写
2.字段名前后要加双引号(注:必须是双引号,单引号将无效)
比如:SELECT * FROM MYTABLE ORDER BY "ORDER"
2022-01-23 16:42:31
ORACLE中,如果表中的字段名,正好跟sql中关键词重名,写sql语句时:
1.要将该字段名大写
2.字段名前后要加双引号(注:必须是双引号,单引号将无效)
比如:SELECT * FROM MYTABLE ORDER BY "ORDER"