Oracle SQL Developer - How to remove double quotes in generated DDL

Question

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.

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?

Thank you, Sydney

Answer 1

Try this:

1. Right click your table and select "Edit"

2. Click "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.

I am using SQL Developer 3.2