This discussion is archived
0 Replies Latest reply: Feb 11, 2013 4:44 PM by 990504 RSS

Export DDL in Export Wizard - Terminator

990504 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points