Terima kasih atas bantuannya pak. tapi saya berencana untuk tidak menggunakan proses looping.karena menurut saya akan berpengaruh pada performance.mengingat proses diluar menghitung hari kerja saja sudah cukup berat.
mungkin ada cara lain? terima kasih Daniel ----- Original Message ----- From: "Andrew E.K." <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, July 22, 2005 3:25 PM Subject: [indo-oracle] Re: working day > Saya coba bantu yah, ini function yg saya gunakan > untuk cari hari kerja saja dengan catatan ada table > untuk data tanggal2 libur nasional sebagai pembanding. > > CREATE OR REPLACE FUNCTION DAYS_BETWEEN (p_start_date > DATE, p_end_date DATE) > RETURN NUMBER > IS > v_days NUMBER DEFAULT 0; > v_date DATE; > v_lbr NUMBER DEFAULT 0; > v_hasil NUMBER DEFAULT 0; > BEGIN > v_date := p_start_date; > > WHILE v_date <= p_end_date > LOOP > IF TRIM(TO_CHAR (v_date, 'Dy')) <> 'Sun' > AND TRIM(TO_CHAR (v_date, 'Dy')) <> 'Sat' > AND TRIM(TO_CHAR (v_date, 'Dy')) <> 'Sab' > AND TRIM(TO_CHAR (v_date, 'Dy')) <> 'Ming' > THEN > v_days := v_days + 1; > END IF; > > SELECT COUNT (*) > INTO v_hasil > FROM Tabel_lbr > WHERE TRUNC(tanggal) = TRUNC(v_date); > > IF v_hasil > 0 THEN > v_lbr := v_lbr + 1; > END IF; > > v_date := v_date + 1; > END LOOP; > > v_days := v_days - v_lbr - 1; > RETURN v_days; > END; > > Semoga membantu :) > > > Andrew > > > --- daniel_d <[EMAIL PROTECTED]> wrote: > > > Saya sedang coba di dua versi 8.1.7 dan 10.1.0.3 > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.323 / Virus Database: 267.9.0/46 - Release Date: 7/16/2005 > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.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/
