double quotes in generated DDL

[lavaller]

Does anyone know how to turn off the double quoting of table names and column names when generating DDL for a given table? I can't find this anywhere in preferences.

 

[Marco Kalter]

Which double quotes do you mean? I don't see them.

 

[lavaller]

Here is an example. I extracted the DDL for the table DUAL. The table name and column name (dummy) are both in quotes is both the table definition and the grant:

CREATE TABLE "SYS"."DUAL"
( "DUMMY" VARCHAR2(1)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 32768 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 1017
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" ;

GRANT SELECT ON "SYS"."DUAL" TO PUBLIC WITH GRANT OPTION;

 

[Marco Kalter]

I think you extracted this through the DBMS_Metadata > DDL popup menu item? This is a standard Oracle package that does indeed use quotes.

If you use any other PL/SQL Developer function to get the DDL (e.g. the Edit function, drag & drop object to editor, Export tools), you will not get any quotes.

 

[lavaller]

That works great!

Thanks