OraFAQ Forum: SQL & PL/SQL » Calender for particular year including US holiday names

Home » SQL & PL/SQL » SQL & PL/SQL » Calender for particular year including US holiday names (Oracle,10.2.0.2,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calender for particular year including US holiday names [message #340916]

Thu, 14 August 2008 22:11

sheker2007
Messages: 19
Registered: November 2007

Junior Member

I need help on Calender using Oracle.
When i pass the year as input need to generate calender for one year.One column need to display date for 1 to 365 days.Another column need to display holiday name if it is holiday if not holiday need to polulate NULL value.Holidays including all weekends and US national holidays.

Experts can any one help on this...

Thanks

Report message to a moderator

Re: Calender for particular year including US holiday names [message #340919 is a reply to message #340916]

Thu, 14 August 2008 22:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

It appears that you did not use the SEARCH function on this forum for "calendar".

Report message to a moderator

Re: Calender for particular year including US holiday names [message #340927 is a reply to message #340916]

Fri, 15 August 2008 00:55

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And of course you must have a table or a rule that defines "holidays".

Regards
Michel

Report message to a moderator

Previous Topic:	CREATE VIEW
Next Topic:	Oracle SubQuery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 09 16:05:06 CDT 2025