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
Subscribe to:
Post Comments (Atom)
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ... -
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment