pbd

CREATE TABLE Mahasiswa (
idMahasiswa VARCHAR2 (11),
nama VARCHAR2 (50),
tglLahir date,
alamat VARCHAR2 (100)
);

DESC MAHASISWA;

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
column_name4 data_type,
...
);

DESC table_name;

DROP TABLE table_name;

INSERT INTO Mahasiswa VALUES
('415010101','BUDI SANTOSO','20-JAN-1990','KALI DERES');
INSERT INTO Mahasiswa VALUES
('41512010116','MUHAJIR','15-JUNI-1994','CIPONDOH');

syntax
INSERT INTO table_name VALUES (value1,value2,value3,..);

select * from Mahasiswa;

BEGIN
INSERT INTO Mahasiswa VALUES ('415010102','JOKO PURNOMO','12-MAR-1994','KALI JODOH');
INSERT INTO Mahasiswa VALUES ('415010103','DARYANTO','13-DES-1990','GONDRONG');
INSERT INTO Mahasiswa VALUES ('415010104','MASBULOH','15-MAR-1993','GOCLONG');
INSERT INTO Mahasiswa VALUES ('415120101','MUHAJIR','17-DES-1994','CIPONDOH');
END

UPDATE table_name set column1=value where some_column=some_value
UPDATE Mahasiswa set alamat='CIPONDOH' where idMahasiswa='415010101';

DELETE FROM table_name where some_column=some_value;
DELETE FROM Mahasiswa where idMahasiswa='415010101';