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 <*> 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/
