i have some data to retrive from one table based upon certain condition.when ever i will query to retrive data [strong]it will return all the data based upon the date range.suppose i will enter 22-jul-2010 then the query should return from the year july-2010 to may be 2011 or 2021.upto the last entry date.if my latest entry 22-mar-2021 it will return all record from jul-2010 to 22-mar-202i.also it will display the all the dates in 'month-yyyy' format. in oracle 10g[/strong]
plz sugest me what will be the query.
August 7, 2010 11:33 AM
August 9, 2010 1:20 PM