I am developing a oracle database for a transactions application. I have come across this problem on selecting date with month & year . i do understand that it is achievable in PL/SQL but i feel there must be a way with just using oracle statement.
Based on my research , below statement is to select month from each row in the table.
select to_char(sysdate, 'Month') from income
ive tried to modify it to my needs but to i failed. So far, i have came out with this statement but it does not work
select * from income where to_char(sysdate,month) = 'feb'
For an example, i will be able to select 'May 2012' instead of displaying all the records. Anybody did ever stumble this problem before?
Thank you in advance :)