Thursday, 27 June 2013

OTL-List of Rotation Plan updates as on sysdate

SELECT NAME,
       (CASE
           WHEN TRUNC (SYSDATE) = TRUNC (last_update_date)
              THEN 'YES'
           ELSE 'NO'
        END) "CHANGE", TO_CHAR (last_update_date, 'DD-MON-RRRR') "Last Update Date"
  FROM hxt_rotation_plans
 WHERE 1 = 1
 ORDER BY 2 desc
Posted by at

1 comment:

  1. Ezra Abram26 January 2021 at 22:14

    I feel really happy to see your webpage here and i spend a lot of time reading here.Same as your blog i found another one Oracle Fusion Cloud Technical.Actually I was looking for the same information on internet for Oracle Fusion HCM Technical and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for your creative ideas.

    ReplyDelete

Subscribe to: Post Comments (Atom)