0 Replies Latest reply: Feb 11, 2013 6:44 PM by 990504 RSS

    Export DDL in Export Wizard - Terminator

    990504
      Hello,

      I am using SQL Developer and looking for a way to change the statement terminator to '/'. By default it uses a semicolon.

      I am exporting Object types tables and triggers.

      while my table has
      CREATE TABLE "SCHEMA"."CONTACT"
         (     "CONTACT_TYPE_ID" NUMBER(9,0), 
           "VALUE" VARCHAR2(120 CHAR)
         ) 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)
        TABLESPACE "SCHEMA_LARGE";
      semiconlon as terminator

      my trigger has
       CREATE OR REPLACE TRIGGER "BILLING_SCHEMA"."SUMMARY_DETAIL" BEFORE INSERT ON SCHEMA.SUMMARY_DETAIL FOR EACH ROW 
      BEGIN SELECT SCHEMA.SEQ_IMPORT_SUMMARY_DETAIL.NEXTVAL INTO :NEW.ID FROM DUAL; END; 
      /
      slash as the terminator because of an already existing semicolon in the trigger statement.

      Could you please help me with a way to standardize the statement terminator to a slash.

      Thanks in advance,
      Marilyn

      Edited by: user5417526 on 11/02/2013 16:43