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

How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...