1. DECLARE
2. nilai1 int(5);
3. nilai2 int(5);
4. nilaih int(5);
5. nilaiAVG int(5);
6.  
7.  
8. BEGIN
9. nilai1:= '&input1';
10. nilai2:= '&input2';
11. nilaih:= '&input3';
12. nilaiAVG := (nilai1+nilai2+nilaih)/3;
13. if nilaiAVG>=90 THEN
14.         dbms_output.put_line('Nilai akhir: '||nilaiAVG||' index: A');
15.  
16. elsif (nilaiAVG between 80 and 89) THEN
17.         dbms_output.put_line('Nilai akhir: '||nilaiAVG||' index: B');
18.  
19. elsif (nilaiAVG between 70 and 79) THEN
20.         dbms_output.put_line('Nilai akhir: '||nilaiAVG||' index: C');
21.  
22. elsif (nilaiAVG between 60 and 69) THEN
23.         dbms_output.put_line('Nilai akhir: '||nilaiAVG||' index: D');
24.        
25. End if;
26. END;
27.  
28.         ======
29. create table siswa(
30.         nim varchar2(10),
31.         nama varchar2(10),
32.         jurusan varchar2(10));
33.        
34.         insert all
35.         into siswa values('002','saitama','D3 Tinju')
36.         into siswa values('009','tyson','D3 Tinju')
37.         into siswa values('099','goku','D3 Tinju')
38.         select 1 from dual;
39.  
40. DECLARE
41. nim1 varchar2(10);
42. nama2 varchar2(10);
43. jurusan3 varchar2(10);
44. cari varchar2(10);
45.  
46. BEGIN  
47. cari:='&input';
48. select nim,nama,jurusan into nim1,nama2,jurusan3 FROM siswa where nim=cari;
49.         dbms_output.put_line('NIM: '||nim1);
50.         dbms_output.put_line('NAMA: '||nama2);
51.         dbms_output.put_line('JURUSAN: '||jurusan3);
52.  
53.        
54. END;
55. /
56.