TUTORIAL MEMBUAT PHYSICAL DATABASE DARI ORACLE SQL DEVELOPER

Tutorial kasar :

-sqlplus oa/oa

-connect as sysdba;

-create user paijo identified by paijo;

-grant all privilege to paijo;

-connect paijo/paijo

-show user

//lalu buat file di oracle home dengan nama paijo.sql dengan isi:
=========================================

DROP TABLE "DOKTERS";
DROP TABLE "PASIENS";
DROP TABLE "DIAGNOSAS";

CREATE TABLE DOKTERS
("ID_DTR" VARCHAR (7),
"NAMA" VARCHAR (25) NOT NULL,
"ALAMAT" VARCHAR (30) NOT NULL,
CONSTRAINT "ID_DTR_PK" PRIMARY KEY ("ID_DTR") USING INDEX ENABLE);

CREATE TABLE PASIENS
("ID_PSN" VARCHAR (9),
"NAMA" VARCHAR (25) NOT NULL,
"ALAMAT" VARCHAR (30),
CONSTRAINT "ID_PSN_PK" PRIMARY KEY ("ID_PSN") USING INDEX ENABLE);

CREATE TABLE DIAGNOSAS
("TANGGAL" DATE,
"HASIL" VARCHAR (30) NOT NULL,
"ID_DTR" VARCHAR (7),
"ID_PSN" VARCHAR (9),
CONSTRAINT "TGL_PK" PRIMARY KEY ("TANGGAL", "ID_DTR", "ID_PSN") USING INDEX ENABLE);

======================================

-@paijo.sql

-desc dokters;

-desc pasiens;

-desc diagnosas;
//lalu buat file di oracle home dengan nama alter_paijo.sql dengan isi:

=====================================

ALTER TABLE DIAGNOSAS ADD CONSTRAINT "DIA_ID_DTR" FOREIGN KEY ("ID_DTR") REFERENCES DOKTERS ("ID_DTR");
ALTER TABLE DIAGNOSAS ADD CONSTRAINT "DIA_ID_PSN" FOREIGN KEY ("ID_PSN") REFERENCES PASIENS ("ID_PSN");

===================================

-@alter_paijo.sql

//lalu buat file di oracle home dengan nama isi_paijo.sql dengan isi:
===================================

INSERT INTO DOKTERS VALUES('D100799','PAIJO','JALAN IN AJA');
INSERT INTO DOKTERS VALUES('D120498','PAINO','JALAN JALAN');
INSERT INTO DOKTERS VALUES('D071297','PAIWO','JALAN YANG BENAR');

INSERT INTO PASIENS VALUES('PSN130193','JARWO','JALAN LURUS');
INSERT INTO PASIENS VALUES('PSN040494','JARVIS','JALAN GRAK');
INSERT INTO PASIENS VALUES('PSN121212','JARAN','JALAN BERBELOK');

INSERT INTO DIAGNOSAS VALUES(TO_DATE('18-12-18','DD-MM-YY'),'PARU KERING','D100799','PSN130193');
INSERT INTO DIAGNOSAS VALUES(TO_DATE('19-12-18','DD-MM -YY'),'KAGETAN','D120498','PSN040494');
INSERT INTO DIAGNOSAS VALUES(TO_DATE('20-12-18','DD-MM-YY'),'GATEL','D071297','PSN121212');

================================

-@isi_paijo.sql

-select * from dokters;

-select * from pasiens;

-select * from diagnosas;

//lalu buat file di oracle home dengan nama select_paijo.sql dengan isi:
==============================

SELECT DOKTERS.ID_DTR, DOKTERS.NAMA, PASIENS.ID_PSN, PASIENS.NAMA, DIAGNOSAS.TANGGAL, DIAGNOSAS.HASIL
FROM DOKTERS, PASIENS, DIAGNOSAS
WHERE DOKTERS.ID_DTR = DIAGNOSAS.ID_DTR AND
PASIENS.ID_PSN= DIAGNOSAS.ID_PSN

===========================

-@select_paijo.sql

Видео TUTORIAL MEMBUAT PHYSICAL DATABASE DARI ORACLE SQL DEVELOPER канала Dhymas Julyan Riyanto