I am using Oracle SQL Developer 3.0. When I script out the BONUSES table under the DEPT schema, just as an example, it produces this DDL.
我正在使用Oracle SQL Developer 3.0。当我在DEPT模式下编写加值表时,它会生成这个DDL。
CREATE TABLE "DEPT"."BONUSES"
( "NEW_EMPLOYEE_ID" NUMBER,
"BONUS" NUMBER DEFAULT 100
) ;
I don't want the double quotes to be included. I have looked through Tools -> Preferences and am not able to find a setting to turn if "off". Is it possibe to suppress the quotes and does anyone know how to do this?
我不希望包含双引号。我查看了工具——>首选项,无法找到一个设置来关闭“off”。有没有可能隐藏引号,有人知道怎么做吗?
Thank you, Sydney
谢谢你,悉尼
2 个解决方案
#1
4
Try this:
试试这个:
-
Right click your table and select "Edit"
右键单击您的表并选择“编辑”
-
Click "DDL"
点击“DDL”
-
Choose "Create"
选择“创建”
This is different from selecting the "SQL" tag on your right panel, you get no double quotes or schema name added.
这与在您的右面板上选择“SQL”标记不同,您没有添加双引号或模式名。
I am using SQL Developer 3.2
我使用的是SQL Developer 3.2
#2
1
Victor,
维克多,
Your instructions worked beautifully.
你的指示工作的美丽。
For you reading enjoyment, I found this link:
为了你的阅读乐趣,我找到了这个链接:
https://kr.forums.oracle.com/forums/thread.jspa?messageID=10628798
https://kr.forums.oracle.com/forums/thread.jspa?messageID=10628798
Doesn't this sound like the Oracle developers posted this question to their own people for comments/reviews? :) They should provide a setting to turn it OFF or ON.
这听起来不像是Oracle开发人员将这个问题提交给他们自己的人进行评论/评论吗?他们应该提供一个设置来关闭或打开它。
Thanks
谢谢
#1
4
Try this:
试试这个:
-
Right click your table and select "Edit"
右键单击您的表并选择“编辑”
-
Click "DDL"
点击“DDL”
-
Choose "Create"
选择“创建”
This is different from selecting the "SQL" tag on your right panel, you get no double quotes or schema name added.
这与在您的右面板上选择“SQL”标记不同,您没有添加双引号或模式名。
I am using SQL Developer 3.2
我使用的是SQL Developer 3.2
#2
1
Victor,
维克多,
Your instructions worked beautifully.
你的指示工作的美丽。
For you reading enjoyment, I found this link:
为了你的阅读乐趣,我找到了这个链接:
https://kr.forums.oracle.com/forums/thread.jspa?messageID=10628798
https://kr.forums.oracle.com/forums/thread.jspa?messageID=10628798
Doesn't this sound like the Oracle developers posted this question to their own people for comments/reviews? :) They should provide a setting to turn it OFF or ON.
这听起来不像是Oracle开发人员将这个问题提交给他们自己的人进行评论/评论吗?他们应该提供一个设置来关闭或打开它。
Thanks
谢谢