Home » SQL & PL/SQL » SQL & PL/SQL » Calender for particular year including US holiday names (Oracle,10.2.0.2,Linux)
Calender for particular year including US holiday names [message #340916] Thu, 14 August 2008 22:11 Go to next message
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
Re: Calender for particular year including US holiday names [message #340919 is a reply to message #340916] Thu, 14 August 2008 22:38 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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".
Re: Calender for particular year including US holiday names [message #340927 is a reply to message #340916] Fri, 15 August 2008 00:55 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And of course you must have a table or a rule that defines "holidays".

Regards
Michel
Previous Topic: CREATE VIEW
Next Topic: Oracle SubQuery
Goto Forum:
  


Current Time: Sun Dec 11 00:31:06 CST 2016

Total time taken to generate the page: 0.06493 seconds