Oracle SQL Developer——如何在生成的DDL中删除双引号

时间:2022-03-12 05:45:18

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:

试试这个:

  1. Right click your table and select "Edit"

    右键单击您的表并选择“编辑”

  2. Click "DDL"

    点击“DDL”

  3. 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:

试试这个:

  1. Right click your table and select "Edit"

    右键单击您的表并选择“编辑”

  2. Click "DDL"

    点击“DDL”

  3. 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

谢谢