top of page

How to last compile data and time in Oracle

  • Writer: Rumesh Aponso (RMAX)
    Rumesh Aponso (RMAX)
  • Nov 20, 2024
  • 1 min read
SELECT t.last_ddl_time, t.*
FROM   all_objects t
WHERE  t.object_type = 'PACKAGE BODY'
AND    t.OBJECT_NAME = 'CUSTOMER_ORDER_API';

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page