create custom function in oracle (merged) [message #430278] |
Mon, 09 November 2009 22:14  |
shiva_jm
Messages: 9 Registered: November 2009
|
Junior Member |
|
|
Any tips on how to create a function that produces the following output. I am new to SQL.
Assuming a default one time value is set '10/10/2009',
function next() should return 10/20/2009, then last day of month, then 11/10/2009, then 11/20/2009, then last day of november and goes on...
So basically I need 10th, 20th and last day of every month when I call the next function 
Thank you
|
|
|
|
|
|
|
|