GeekInterview | Geeks Forum | Online Quiz | Learning Center | Privacy | Terms and Conditions | Contact
GeekInterview Code Base
Code Snippets Login Register

Oracle Calendar SQL

This oracle query returns Calendar for the current year.
09 November, 2006
jamesravid
0
N/A
This Oracle SQL query returns Calendar for the current year.
Calendar.sql [ Download ]

 

Comments [ Leave Comment ]

Posted by sargas at 29 January, 2008
this code is not enough to show the calender
I guess you miss some code.
Posted by James at 24 February, 2008
Hi,

There is one prerequisite for this query. It is "Number of records in user_objects table should have 365 (366 for leap years). Better you can replace user_objects with all_objects since the later one contains more rows than the earlier.

Hope this helps.

Cheers,
James

 

Tips [ Leave Tip ]

No tips added yet. Be the first one to share tip.

 

Reviews [ Leave Review ]

No reviews added yet. Be the first one to review.

 

Tags

Database

 

Related Items

C++ Portable Components
SQL to find "Experience of employee"
Customer List With Edit and Delete Options
File Retriever
Increment and Decrement Date Value using hot Keys + / -

 

Related Categories

Database » SQL Server
Oracle » Database » SQL
DB2 » Database » SQL
Database » MYSQL
MYSQL » Database » MySQL
Copyright @GeekInterview.com