|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
DROP TABLE TBL_CHILD_1ST; DROP TABLE TBL_CHILD_2ND; DROP TABLE TBL_PARENT_1ST; DROP TABLE TBL_PARENT_2ND; CREATE TABLE "TBL_PARENT_1ST" ( "KODE" NVARCHAR2(20) NOT NULL ENABLE, "NAMA" NVARCHAR2(20), "KETERANGAN" NVARCHAR2(100), CONSTRAINT "PK_TBL_PARENT_1ST" PRIMARY KEY ("KODE")); CREATE TABLE "TBL_PARENT_2ND" ( "KODE" NVARCHAR2(20) NOT NULL ENABLE, "NAMA" NVARCHAR2(20), "KETERANGAN" NVARCHAR2(100), CONSTRAINT "PK_TBL_PARENT_2ND" PRIMARY KEY ("KODE")); CREATE TABLE "TBL_CHILD_1ST" ( "KODE" NVARCHAR2(20) NOT NULL ENABLE, "NAMA" NVARCHAR2(20), "KETERANGAN" NVARCHAR2(100), "KODE_PARENT" NVARCHAR2(20), CONSTRAINT "PK_TBL_CHILD_1ST" PRIMARY KEY ("KODE"), CONSTRAINT "FK_TBL_CHILD_1ST_1" FOREIGN KEY ("KODE_PARENT") REFERENCES "TBL_PARENT_1ST" ("KODE") ON DELETE CASCADE); CREATE TABLE "TBL_CHILD_2ND" ( "KODE" NVARCHAR2(20) NOT NULL ENABLE, "NAMA" NVARCHAR2(20), "KETERANGAN" NVARCHAR2(100), "KODE_PARENT" NVARCHAR2(20), CONSTRAINT "PK_TBL_CHILD_2ND" PRIMARY KEY ("KODE"), CONSTRAINT "FK_TBL_CHILD_2ND_1" FOREIGN KEY ("KODE_PARENT") REFERENCES "TBL_PARENT_2ND" ("KODE") ON DELETE CASCADE); CREATE INDEX "IX_TBL_CHILD_1ST_1" ON "TBL_CHILD_1ST" ("KODE_PARENT"); CREATE INDEX "IX_TBL_CHILD_2ND_1" ON "TBL_CHILD_2ND" ("KODE_PARENT"); |
Dan jangan lupa perhatikan setiap membuat foreign key menggunakan action on delete cascade anda harus menambahkan index-nya.
Semoga cukup membantu pemahaman anda dalam memproses data di database oracle.
Salam berbagi,
Pages: 1 2
