CODEWITHSUNDEEP
sqloracle-database
Pinchas K
Pinchas K

Reputation: 1571

Oracle sp's list - latest updated?

I want to run a query in Oracle pl SQL that will tell me which SP's have been updated most recently. In SQL Server it would be this: 

select name, modify_date 
from sys.procedures 
order by modify_date desc

Upvotes: 1

Views: 93

Answers (2)

Y__
Y__

Reputation: 1777

Did you try this query :

select *  from user_objects 
where object_type = 'PROCEDURE'
ORDER BY LAST_DDL_TIME DESC

You may also want to use this table to see all procedures : all_objects

Upvotes: 1

João Silva
João Silva

Reputation: 91349

Query the dba_objects table:

SELECT object_name, last_ddl_time
FROM dba_objects
WHERE object_type = 'PROCEDURE'
ORDER BY last_ddl_time DESC

Upvotes: 2

Related Questions