Saya sedang coba di dua versi 8.1.7 dan 10.1.0.3 ----- Original Message ----- From: "adhi Januardi" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, July 04, 2005 1:25 PM Subject: Re: [indo-oracle] Re: working day
> oracle versi berapa ya...? > > --- mg_simon <[EMAIL PROTECTED]> wrote: > > > salam, > > saya ngak tau yg kamu mau itu seperti apa, soalnya > > di Oracle itu ada > > BOM working day, HR working day, etc.. > > ini adalah contoh BOM working day (tgl produksi) > > > > select Count(CALENDAR_DATE) > > from BOM_CALENDAR_DATES > > where SEQ_NUM is not null > > and NEXT_SEQ_NUM is not null > > and PRIOR_SEQ_NUM is not null > > and prior_date=next_date > > and > > > to_char(CALENDAR_DATE,'MON-YYYY')=to_char(:P_DATE,'MON-YYYY') > > and calendar_code=(Select calendar_code > > From BOM_CALENDARS > > Where calendar_code=(Select > > CALENDAR_CODE > > From > > MTL_PARAMETERS > > Where > > ORGANIZATION_ID=:P_ORGANIZATION_ID)); > > > > > > --- In [email protected], "daniel_d" > > <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > saya sedang mencari sql statement untuk mencari > > working day dalam satu > > > bulan. > > > ada yang ide? > > > > > > Daniel > > > > > > > > > > > ____________________________________________________ > Yahoo! Sports > Rekindle the Rivalries. Sign up for Fantasy Football > http://football.fantasysports.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.8.10/43 - Release Date: 7/6/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/
