Mungkin bisa membantu, tapi kalo bisa usaha aja dulu ya.. select a.NIM, c.nama, b.Nama_MK, a.Nilai from Nilai_MK a inner join data_MK b on a.Kode_MK = b.Kode_MK inner join DataMHS c on a.NIM = c.NIM order by a.NIM
Nilai_MK = Nilai data_MK = matakuliah DataMHS = Mahasiswa jangan copas aja ya.. dipelajari dan dipahami juga, Thanks best Rgrds Febry Canna ________________________________ From: Febry Kurniawan <[email protected]> To: [email protected] Sent: Wed, December 30, 2009 7:27:07 PM Subject: Re: [indo-oracle] tanya Prosedur untuk veiw Wow tugas kuliah ya bro. Udah coba buat sendiri lom? Kan ada contoh membuat store procedure. Digoogle jg banyak. Sorry bukan ga mau bantu n sok ngajarin. Tapi usaha dulu. :) Thx Sent from my AXIS Worry Free BlackBerry® smartphone -----Original Message----- From: dedi heri <ho_...@yahoo. com> Date: Tue, 29 Dec 2009 19:49:10 To: <indo-oracle@ yahoogroups. com> Subject: [indo-oracle] tanya Prosedur untuk veiw diketahui tabel SQL> select * from mahasiswa; NIM NAMA ALAMAT -------- ------------ -------- ------------ -------- 08650001 budi magelang 08650002 siti jayapura 08650003 joko sleman 08650004 adi sleman 08650005 budhe coba surabaya SQL> select * from matakuliah; KODE_ NAMA_MK JENIS_MK ----- ------------ -------- ---------- 111 pascal waajib 112 delphi waajib 113 desain pilihan SQL> select * from nilai; NIM KODE_ NI -------- ----- -- 08650001 111 a 08650001 112 c 08650002 111 c 08650003 113 c 08650001 113 08650002 113 a 08650002 112 08650003 112 b 08650003 111 9 rows selected. kemudian bagaimana membuat sebuah procedure yang jika di eksekusi akan menampilkan output seperti dibawah ini SQL> execute lihat_mk('08650001' ); NIM NAMA MATAKULIAH NILAI 08650001 budi pascal a 08650001 budi delphi c 08650001 budi desain Mohon bantuannya.. .. terima kasih [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
