Need query to retrieve data from a given date in Oracle 10g

50 pts.
Tags:
Oracle
Oracle 10g
Oracle Data Access
Oracle Database
Oracle Query
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.

 



Software/Hardware used:
oracle

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try something like this:

<pre>SELECT TO_CHAR(entry_date,’month-yyyy’), column_x, column_y, column_z
FROM your_table
WHERE entrty_date >= ‘&start_date';</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following