INSERT ALL

INTO mahasiswa VALUES ('120010001','RAIHAN','BANDUNG',TO_DATE('12091997','DDMMYYYY'),'JATINANGOR','P001')

INTO mahasiswa VALUES ('120020001','NAILA','JAKARTA',TO_DATE('07091997','DDMMYYYY'),'CIBIRU','P002')

INTO mahasiswa VALUES ('120020002','BUDI','BANDUNG',TO_DATE('11101997','DDMMYYYY'),'CIBIRU','P002')

INTO mahasiswa VALUES ('120030001','ANA','BANDUNG',TO_DATE('12121997','DDMMYYYY'),'CINUNUK','P003')

SELECT 1 FROM DUAL;

CREATE TABLE dosen

(

kode_dosen CHAR(6) NOT NULL,

nama_dosen VARCHAR2(30) NOT NULL,

tempat_lahir VARCHAR2(20) NOT NULL,

tanggal_lahir DATE NOT NULL,

alamat_dosen VARCHAR2 NOT NULL,

PRIMARY KEY (kode_dosen)

);

CREATE TABLE jurusan

(

kode_jurusan CHAR(6) NOT NULL,

nama_jurusan VARCHAR2(30) NOT NULL,

deskripsi VARCHAR2(50) NOT NULL,

PRIMARY KEY (kode_jurusan)

);

INSERT ALL

INTO mahasiswa VALUEs ('P001','MI','MANAJEMEN INFORMASI')

INTO mahasiswa VALUEs ('P002','SI','SISTEM INFORMASI')

INTO mahasiswa VALUEs ('P001','SIA','SISTEM INFORMASI AKUNTANSI')

SELECT 1 FROM SINGLE;

ALTER TABLE dosen

  MODIFY alamat_dosen varchar2;

wmic and exit to fullscreen

Syntax

ALTER TABLE table_name
  ADD (column_1 column_definition,
       column_2 column_definition,
       ...
       column_n column_definition);

Sesi Selanjutnya

CREATE TABLE buku 
( 
kode_buku VARCHAR2(9), 
judul_buku VARCHAR2(30), 
id_pengarang VARCHAR2(9), 
penerbit VARCHAR(20), 
status VARCHAR2(8), 
PRIMARY KEY (kode_buku) 
); 

CREATE TABLE pengarang
( 
id_pengarang VARCHAR2(9), 
nama_pengarang VARCHAR2(30), 
Alamat VARCHAR2(20), 
no_telp VARCHAR(20),  
PRIMARY KEY (id_pengarang) 
); 

INSERT ALL
INTO buku VALUES ('BB000-001','Pengenalan PL/SQL','AA000-001','Informatika','Ada')
INTO buku VALUES ('BB000-002','Konsep Basis Data','AA000-002','Grafindo','Dipinjam')
INTO buku VALUES ('BB001-002','Algoritma','AA001-002','Informatika','Ada')
INTO buku VALUES ('BB001-003','Fikih Islam','AA001-003','Mizan','Ada')
SELECT 1 FROM DUAL;

INSERT ALL
INTO pengarang VALUES ('AA000-001','Andi','JL. Banda','0896788790')  
INTO pengarang VALUES ('AA000-002','Fathansyah','JL. Merdeka','081234456')
INTO pengarang VALUES ('AA001-002','Leony','JL. Banda','0898788857')
INTO pengarang VALUES ('AA001-003','Abdul','JL. Citarum','089906098')
SELECT 1 FROM DUAL;

ALTER TABLE pengarang
  MODIFY alamat_dosen varchar2;

NEXT SESSION PARAMETERS

SQL> connect
Enter user-name: system
Enter password:
Connected.
SQL> ALTER USER HR IDENTIFIED BY 123 ACCOUNT UNLOCK;

User altered.

SQL> connect
Enter user-name: HR
Enter password:
Connected.
SQL> SET SERVEROUTPUT ON;
SQL> CREATE OR REPLACE PROCEDURE VIEW_COUNTRY AS
  2  CURSOR Ccountry IS SELECT * FROM COUNTRIES;
  3  BEGIN
  4  FOR hasil IN Ccountry LOOP
  5  DBMS_OUTPUT.PUT_LINE (hasil.COUNTRY_ID);
  6  DBMS_OUTPUT.PUT_LINE (hasil.COUNTRY_NAME);
  7  DBMS_OUTPUT.PUT_LINE (hasil.REGION_ID);
  8  END LOOP;
  9  END;
 10  /

Procedure created.

Fix Error
SHOW ERROR PROCEDURE nama.prosedur