如何在Orcle中省略围绕字段和表格的双引号？ [英] How to omit double quote wrapping around field and table in Orcle?

问题描述

我的 Orcle 有问题。要访问每个字段和表，它需要双引号环绕。



例如：从文章中选择num，author



我想省略这些双引号，我该怎么办？

I have problem with my Orcle. To access each field and table, it required double quote wrapping around.

For example: select "num", "author" from "article"

I wanna omit these double quote, what should I do?

推荐答案

问题是Oracle区分大小写。在使用它之前，它会将任何未封闭的（双引号）列名转换为大写。通过封闭它，您确保按原样使用它！如果您在没有这些双引号的情况下出现错误，则意味着您将列打包为小写...

The problem is that Oracle is case sensitive. It will convert any not enclosed (in double quotes) column name to uppercase before using it. By enclosing it you ensure to use it as it is! If you have error without those double quotes it means that you crated you columns lowercase...

这篇关于如何在Orcle中省略围绕字段和表格的双引号？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！