Sunday, August 20, 2017

How to set company wise month


SQL> select MAX(ADD_MONTHS(trunc(at_dt,'MON')+25,-1)) into :dt1 from emp_attn_data
  2    where at_dt <> (select max(add_months(trunc(at_dt,'mon')+25,0)) from emp_attn_data);

MAX(ADD_M
---------
26-JUL-17

SQL> select MAX(ADD_MONTHS(trunc(at_dt,'MON')+25,-1)) into :adt from emp_attn_data;

MAX(ADD_M
---------
26-JUL-17

SQL> select MAX(trunc(at_dt,'MON')+24) into :adt from emp_attn_data;

MAX(TRUNC
---------
25-AUG-17

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...