blocks|key|420181|text|如果您适当地引用这些内容，您就可以(参见the+Oracle+doc)。然而，我怀疑这不是一个好主意，因为你必须引用所有的东西。通常，数据库命名标准/约定(例如here或here)更喜欢使用下划线(不需要引号)而不是空格。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|420182|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm|1|http://www.gplivna.eu/papers/naming_conventions.htm|2|http://ss64.com/ora/syntax-naming.html^0|K|E|0|28|4|1|2D|4|2|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]|$A|W|B|X|1|Y]]|C|$]]|$1|D|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]|N|$5|G|H|I|C|$J|O]]]]

You can (see <a href="http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm" rel="nofollow">the Oracle doc</a>) if you quote these appropriately. However I suspect this is not a good idea, since you'll have to quote everything. Generally db naming standards / conventions (e.g. <a href="http://www.gplivna.eu/papers/naming_conventions.htm" rel="nofollow">here</a> or <a href="http://ss64.com/ora/syntax-naming.html" rel="nofollow">here</a>) favour using underscores (which don't require quoting) over whitespace.

blocks|key|201863|text|是的，这是可能的。您只需确保引用列名即可。例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|201864|CREATE+TABLE+Fubar+("Foo+Bar"+INT);
INSERT+INTO+Fubar+VALUES+(1337);
SELECT+"Foo+Bar"+FROM+SpaceMonster|code-block|syntax|javascript|201865|尽管这是可能的，但这并不是一个好主意。如果用下划线替换所有的空格，你可能会避免很多痛苦。|201866|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Yes, it's possible. You just have to be sure to quote the column name. For instance:

<pre><code>CREATE TABLE Fubar ("Foo Bar" INT);
INSERT INTO Fubar VALUES (1337);
SELECT "Foo Bar" FROM SpaceMonster
</code></pre>

Even though it's possible, it doesn't make it a good idea. You'll probably save yourself from a lot of pain if just replace all you spaces with underscores.

blocks|key|201913|text|你在谷歌上搜索过这个吗？我做到了-第六个链接是this，在其中我找到了以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|201914|create+table+employee+(
+++"First+Name"+varchar2(20),
+++"Last+Name"+varchar2(20),
+++Address+varchar2(60),
+++Phone+varchar2(15),
+++Salary+number,
+++EmpID+number,
+++DeptID+number
);+|code-block|syntax|javascript|201915|..。当我在10g中尝试它时，它工作得很好。|201916|entityMap|0|LINK|mutability|MUTABLE|url|http://www.devshed.com/c/a/Oracle/Oracle-Database-Fundamentals/1/^0|N|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

Did you Google for this? I did - the 6th link was <a href="http://www.devshed.com/c/a/Oracle/Oracle-Database-Fundamentals/1/" rel="nofollow">this</a>, in which I find the following:

<pre><code>create table employee (
 "First Name" varchar2(20),
 "Last Name" varchar2(20),
 Address varchar2(60),
 Phone varchar2(15),
 Salary number,
 EmpID number,
 DeptID number
); 
</code></pre>

... which works fine when I tried it in 10g.

blocks|key|201936|text|可以通过将两个"示例之间的列命名为"My+columN“，列名变为区分大小写，这意味着。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|201937|SELECT+"my+column"+from+table;+--NOT+OK
SELECT+"My+columN"+from+table;+--OK|code-block|syntax|javascript|201938|entityMap^0|7|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

it is possible by naming the column between two <code>"</code>
example: "My columN" , the column name becomes case sensitive which means.

<pre><code>SELECT "my column" from table; --NOT OK
SELECT "My columN" from table; --OK
</code></pre>

Is it possible to create a table with column name containing space? If so how can I create and use it?

Oracle table column name with space

数据库

可以创建一个列名包含空格的表吗？如果是这样，我如何创建和使用它？

问带空格的Oracle表列名称
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问带空格的Oracle表列名称EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问带空格的Oracle表列名称
EN