waduh akhirnya ujian kelar juga saatnya liburan neh namun senelum itu langsung tek ketik deh jawaban oracle yang essay nya buat latihan kawan kawan oracle mania dan ini meliputi proses input, update, delete dan declare dijamin 100% jakan dalam sql command di oracle.......langsung nih di bawah ga usah download ga usah ada link langsung copas aja copy paste kaya ga biyasanya aja............^_^.....he he web2030 script tutorial oracle by stikom cki cempaka putih









create table player
(player_id varchar (3),
nama_player varchar (25),
jenis_kelamin varchar (2),
email varchar (20),
tanggal date);

create table skor
(game_id varchar (4),
player_id varchar (3),
try1 number (2),
try2 number(2));

insert into player values ('001', 'Budi', 'L', 'budi@yahoo.com', '29-mar-2007');
insert into player values ('002', 'aris', 'L', 'aris@plaza.com', '12-jan-2007');
insert into player values ('003', 'wanda', 'P', 'wan@hotmail.com', '1-apr-2007');
insert into player values ('004', 'nina', 'P', 'nina@gmail.com', '1-apr-2007');
insert into player values ('005', 'wawan', 'L', 'wa2@ovi.com', '23-may-2007');
select * from player

insert into skor values ('G001', '005', '80', '85');
insert into skor values ('G001', '002', '70', '90');
insert into skor values ('G001', '003', '90', '90');
insert into skor values ('G001', '001', '60', '80');
insert into skor values ('G001', '004', '50', '30');
select * from skor

---------
update
---------

update skor set game_id = 'G002'
where game_id = 'G001';
update skor set player_id = '006'
where player_id = '005'
update skor set try1 = '90'
where try1 = '80'
update skor set try2 = '90'
where try1 = '78'
----------------

delete
----------------
delete from skor where game_id = 'G001'
-----------------

menghitung skor
-------------------------
select try1 + try2 as nilaiskor from skor
--------------------------
////Screen/////
declare
game_id varchar2(6);
player_id varchar2(3);
try1 number(2);
try2 number(2);
Total number(3);
status varchar2(20);

procedure nilai as
begin
Total:=(try1+try2)/2;
if Total >='70' then
game_id:='G001';
player_id:='005';
status:='Selamat';
dbms_output.put_line('Total = '||to_char(Total)||
' Game ID = '||to_char(game_id)||
' Player ID = '||to_char(player_id)||
' Status = '||to_char(status));
else
Status:='Gagal';
dbms_output.put_line('Total = '||to_char(Total)||
' Game ID = '||to_char(game_id)||
' Player ID = '||to_char(player_id)||
' Status = '||to_char(status));

end if;
end;

begin
try1:=80;
try2:=85;
nilai;
end;






okay semoga bermanfaat yah script script nya........