Tag: ADD_MONTHS

Interesting SQL and PLSQL Tips and Tricks

Jun 27, 2014

—

by

Arun Raj

in Oracle Apps, Oracle Apps Technical, Oracle PLSQL

This blog covers some interesting SQL and PLSQL Tips and Tricks. I will try to include some interesting functions and plsql solutions to some interesting requirements. Find Last Day of the Month SQL Function :- LAST_DAY() SELECT LAST_DAY(SYSDATE) FROM DUAL Find First Day of the Current Month SQL Function:- Combination of LAST_DAY () and ADD_MONTHS…