SELECT ADD_MONTHS (TRUNC(SYSDATE,'Y'),ROWNUM -1) MONTH_FIRST_DAY
FROM ALL_OBJECTS
WHERE ROWNUM <= 12
FROM ALL_OBJECTS
WHERE ROWNUM <= 12
Showing posts with label How to find First Date of the Month using Oracle Sql Query. Show all posts
Showing posts with label How to find First Date of the Month using Oracle Sql Query. Show all posts
Thursday, 26 April 2018
Subscribe to:
Posts (Atom)
How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)
How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...
-
Find Customer Bill To and Ship to Address Script in Oracle Apps EBS R12 SELECT HP.PARTY_NAME CUSTOMER_NAME, DECODE (HCSUA.SITE_...
-
How To Enable or Disable Forms Personalization Option in Oracle Apps EBS System To start Forms Personalization navigate to Help -> D... -
----- Script for the BOM Routing Department Query in Oracle apps EBS R12 ---- SELECT (SELECT hou.NAME F...