Home » SQL & PL/SQL » SQL & PL/SQL » Write a single query to print calender
icon13.gif  Write a single query to print calender [message #236485] Thu, 10 May 2007 01:46 Go to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Hello Sir,

Can you help me to write a single i.e. only one Oracle Query to display / print calender.[/B][/B]
Give the different methods for it.

Thank You.
Waiting for reply.
Re: Write a single query to print calender [message #236494 is a reply to message #236485] Thu, 10 May 2007 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems to be a homework.
Post what you already tried (and your Oracle version).
Also, what should be the format of your calendar?

Regards
Michel
Re: Write a single query to print calender [message #236520 is a reply to message #236494] Thu, 10 May 2007 02:50 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Tom Kyte has tackled this one pretty well. I stole his answer for this thread. A search should have revealed it to you too.

MHE
Re: Write a single query to print calender [message #236523 is a reply to message #236494] Thu, 10 May 2007 02:58 Go to previous message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Sir,

I have tried following :

select trunc(sysdate,'y') from all_synonyms
where rownum <= (select count( add_months(trunc(sysdate,'y'),12))
from all_synonyms)

select count (add_months(trunc(sysdate,'y'),-12)) from all_objects

But, it's not working. I am not getting days as 365 for rownum condition.
There is no specific format I expect.
It can be Monthly...

Thanks & Regards,

Previous Topic: dates
Next Topic: Passing variable in IN clause with more than one values
Goto Forum:
  


Current Time: Wed Dec 07 22:16:08 CST 2016

Total time taken to generate the page: 0.11508 seconds