Geek asks and answers

Is it possible to force Oracle SQL Developer to avoid output when exporting as an insert?

Is it possible, and if so, how can I tell Oracle SQL Developer to avoid single quotes when exporting an insert table? It seems obvious what to do by avoiding the character used to quote fields when this happens in a field, but I cannot find a variant of it.

Update: version 2.1.1.64, export method. Context menu> export data> paste ...

+3
source share
1 answer

I just tried this with SQL Developer 3.0.04, and it seems that single quotes in the data are escaped by default:

--------------------------------------------------------
--  File created - Wednesday-June-01-2011   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table T3
--------------------------------------------------------

  CREATE TABLE "THEUSER"."T3" 
   ("C1" VARCHAR2(20 BYTE), 
    "C2" VARCHAR2(20 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
     PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
     STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 
     BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
REM INSERTING into THEUSER.T3
Insert into THEUSER.T3 (C1,C2) values ('C1','C''2');

I have only one row in the table, consisting of the values ​​C1 and C'2.

+1
source

More articles:


All Articles