Knowledge Hub — Technical Document

Generated on 2026-08-28 08:02 | Confidential Client Asset

TimestampDifference

Published February 22, 2026 By Sai Sree Ram Gundepudi 
select
       extract( day from diff )    days
     , extract( hour from diff )   hours
     , extract( minute from diff ) minutes
     , extract( second from diff ) seconds
from
       (
              select
                     max(n1) - min(n1) diff
              from
                     XX_DEBUG
       )

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

More in EBS_Miss
EBS_Miss

API_to_Update_FND_LOOKUP

API to Update FND_LOOKUP DECLARE l_lookup_type VARCHAR2 (250); l_lookup_code VARCHAR2 (250);...

 EBS_Miss

application SN&name

SELECT DISTINCT A.APPLICATION_ID , A.application_short_name , b.application_name , c.RESPO...

 EBS_Miss

code splitter

Fixed Length String -------------------- select SUBSTR('REB|IUF41501|IUF52402|IUF0233|IUF0524|IUF0535',1,INSTR('R...