CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
Johnny Bones
Johnny Bones

Reputation: 8404

Viewing the last edit date of a procedure in Oracle SQL Developer

In SQL Server Management Studio, there's a tab called Object Explorer Details that you can look at to see when a table or a procedure is created or last modified.

Is there something similar for Oracle SQL Developer?

Upvotes: 0

Views: 3278

Answers (2)

thatjeffsmith
thatjeffsmith

Reputation: 22457

View > Reports > Data Dictionary Reports

Open the All Objects Report

enter image description here

You can filter/sort the report to restrict to a specific schema or object type, or even filter on the last updated date (Last_DDL)

Upvotes: 2

Luc M
Luc M

Reputation: 17324

* Query way *

With Oracle, you can query the view all_objects

* GUI way *

Search for the objects that you want and the check the Details tab

Let say you want information about OE_ACKNOWLEDGMENT_PUB package body

Searching for OE_ACKNOWLEDGMENT_PUB package

Then you click on the object name

object name

Then you click on Details tab

Details tab

Upvotes: 1

Related Questions