Hi,
Bisa create function untuk kolom MATKUL
=======
create or replace function get_matkul(p_nama varchar2)
return varchar2
is
v_matkul varchar2(100) := null;
cursor csr(c_nama varchar2)
is
select matkul
from <nama_table>
where nama = p_nama;
begin
for rec in csr(p_nama) loop
v_matkul := v_matkul||', '||rec.matkul;
end loop;
v_matkul := ltrim(v_matkul,', ');
return v_matkul;
end;
=============
querynya jadi begini :
SELECT NAMA,GET_MATKUL(NAMA)
FROM <TABLE_NAME>
GROUP BY NAMA,GET_MATKUL(NAMA);
thanks.
--- In [email protected], "yudi" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Saya mau Tanya, bagaimna sintak untuk query table spt ini:
>
> Table:
> NIM NAMA MATKUL
> 001 TEST1 MATKUL1
> 001 TEST1 MATKUL2
> 001 TEST1 MATKUL3
> 002 TEST2 MATKUL1
> 003 TEST3 MATKUL1
>
> Result:
> NIM NAMA MATKUL
> 001 TEST1 MATKUL1, MATKUL2, MATKUL3
> 002 TEST2 MATKUL1
> 003 TEST3 MATKUL1
>
> THX IN ADVANCED
>
>
> [Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.port5.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
