I need to execute a script, which includes create table's and some insert into this table, but it fails after second execution because of table exists.
Is there a way to have a command like .., create table if not exists.., which dont give me error messages after second execution?
CREATE TABLE BREND
(
ID VARCHAR2(10) PRIMARY KEY NOT NULL,
NAME VARCHAR2(100) NOT NULL
);
INSERT INTO BREND (ID, NAME) VALUES ('1', 'o2');
CREATE TABLE USER_BREND
(
"USER_ID" NUMBER(19,0) NOT NULL ENABLE,
"BREND_ID" VARCHAR2(10) NOT NULL ENABLE,
CONSTRAINT "USER_BREND_PK" PRIMARY KEY ("USER_ID", "BREND_ID"),
CONSTRAINT "USER_BREND_USER_FK" FOREIGN KEY ("USER_ID")
REFERENCES "USER" ("ID") ON DELETE CASCADE ENABLE,
CONSTRAINT "USER_BREND_BREND_FK" FOREIGN KEY ("BREND_ID")
REFERENCES "BREND" ("ID") ON DELETE CASCADE ENABLE
);
COMMENT ON COLUMN "USER_BREND"."USER_ID" IS 'Foreign key for the associated user';
COMMENT ON COLUMN "USER_BREND"."BREND_ID" IS 'Foreign key for the associated brend';
INSERT INTO "USER_BREND" (SELECT ID as USER_ID, '1' as BREND_ID FROM USER")