Basis Data Modul 10 (Query)

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));                         




desc my_employees;


insert into my_employees
values (1, 'Ralph', 'Patel', 'rpatel', 895);


select *
from my_employees;


insert into my_employees
values (2, 'Betty', 'Dance', 'bdance', 860);


select *
from my_employees;


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 *
from my_employees;


UPDATE my_employees
set last_name = 'Drexler'
where id = 3;


select *
from my_employees;


UPDATE my_employees
set salary = 1000
where salary < 900;


select *
from my_employees;


DELETE from my_employees
WHERE first_name = 'Betty';


SELECT *
from my_employees;

nb: jika anda memakai SQL Express, maka harus di setting terlebih dahulu...!!