skip to main
|
skip to sidebar
Sql Tips & Tricks
Wednesday, January 24, 2007
Getting Dates whether Transaction is there on not
SELECT TO_DATE(:FROM_DATE,'DD/MM/YYYY')+(ROWNUM-1) AS SUPV_DATE,
NULL AS SUPV_HRS,
NULL AS SUPV_OT
FROM ALL_OBJECTS
WHERE TO_DATE(:FROM_DATE,'DD/MM/YYYY') + (ROWNUM - 1) <= TO_DATE(:END_DATE,'DD/MM/YYYY')
Newer Post
Older Post
Home
Subscribe via email
Enter your email address:
Delivered by
FeedBurner
Blog Archive
►
2009
(7)
►
October
(3)
►
September
(1)
►
August
(1)
►
July
(1)
►
March
(1)
►
2008
(8)
►
December
(2)
►
October
(1)
►
August
(1)
►
July
(3)
►
May
(1)
▼
2007
(5)
►
April
(1)
►
February
(1)
▼
January
(3)
Peace in your life.
How to Install Microsoft office document image wri...
Getting Dates whether Transaction is there on not
►
2006
(1)
►
December
(1)
About Me
Abdoul Rahaman
View my complete profile