Memanipulasi data menggunakan SQL Developer
pada bagian ini pertama-tama anda harus masuk ke aplikasinya terlebih dahulu,kemudian baru lah anda masukan perintah dibawah ini.

Data Manipulation Language (DML) adalah bagian inti dalam SQL.Perintah DML diperlukan ketika kita melakukan hal-hal berikut:
1. Menambah baris baru dalam tabel
2. Memodifikasi baris yang ada dalam tabel
3. Menghapus baris yang ada dalam tabel
Sekumpulan perintah DML yang membentuk satu unit logikal disebut transaksi.

INSERT into departments (department_id, department_name, manager_id, location_id)
values (70, 'Public Relations', 100, 1700);

--1
CREATE TABLE my_employees (
id NUMBER(4)
CONSTRAINT emp_id_pk PRIMARY KEY
,first_name VARCHAR2(20)
,last_name VARCHAR2(25)
,userid VARCHAR2(8)
,salary NUMBER(8,2));

--2
select *
from my_employees;

--3
INSERT INTO my_employees
values (1, 'Ralph', 'Patel', 'rpatel', 895);

select id, first_name, last_name, userid, salary
from my_employees;

--4
INSERT INTO my_employees (id, first_name, last_name, userid, salary)
values (2, 'Betty', 'Dance', 'bdance', 860);

select id, first_name, last_name, userid, salary
from my_employees;
--5
INSERT INTO my_employees
values (3, 'Ben', 'Biri', 'bbiri', 1100);

insert into my_employees
values (4, 'Chad', 'Newman', 'cnewman', 750);

insert into my_employees
values (5, 'Audrey', 'Ropeburn', 'aropebur', 1550);

select id, first_name, last_name, userid, salary
from my_employees;
--6
UPDATE my_employees
set last_name = 'Drexler'
where id = 3;

select id, first_name, last_name, userid, salary
from my_employees;
--7
update my_employees
set salary = salary + 1000
where salary < 900;

select id, first_name, last_name, userid, salary
from my_employees;
--8
delete from my_employees
where first_name = 'Betty';

select id, first_name, last_name, userid, salary
from my_employees;