All About Oracle Apps
Thursday, May 1, 2025
Converting Comma separated string to Rows using SQL
›
WITH rws AS (SELECT ',Bala,Mithu,Achu,Comma,' str FROM DUAL) SELECT REGEXP_SUBSTR (str, '[^,]+', 1, LEVEL) VALUE F...
Wednesday, April 30, 2025
Creating DFF for Lookup in Oracle Fusion
›
1. Manage Descriptive Flexfields 2. Search the Flexfield Code : FND_LOOKUP_VALUES_B 3. Click Edit Icon 4. Click Manage Contexts 5. Creat...
Job Anniversary Days
›
Formulas Years : DATEDIF (A2,B2," Y ") Months : DATEDIF (A2,B2," YM ") Days : DATEDIF (A2,B2," MD ") I...
Export To Excel From BIP Report - Date Format Is General And Doesn't Convert To Date
›
Symptoms After you export the BI Report to excel, the date format is shown as general in Excel and doesn't convert to date. This ...
Tuesday, January 9, 2024
Query to get years as list of values
›
WITH years AS ( SELECT ADD_MONTHS (TO_DATE ('01-01-2020', 'DD-MM-YYYY'), LEVEL * 12) year FROM DUAL ...
›
Home
View web version
