Query to Select the First Day and Last Day of the Current Month
select trim(to_date(last_day(sysdate),’DD/MM/YYYY’)) as lastday from dual;
select trunc((sysdate),’month’) as FirstDay from dual;
Mike Dietrich's Blog About Oracle Database Upgrades... Mostly
Life isn't about finding yourself. Life is about creating yourself.
The power of Oracle & information Technology.
Yet another look on Oracle latch performance
Unix & Oracle stories
Remarks of the programmer
The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes