How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside)

  How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside) If you've ever administered Oracle E-...

Thursday, 26 April 2018

How to find First Date of the Month using Oracle Sql Query

SELECT ADD_MONTHS (TRUNC(SYSDATE,'Y'),ROWNUM -1) MONTH_FIRST_DAY
FROM ALL_OBJECTS
WHERE ROWNUM <= 12

No comments:

Post a Comment