[ACCEPTED]-Oracle get stored procedure last modified date-oracle
Accepted answer
SELECT LAST_DDL_TIME, TIMESTAMP
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE'
AND OBJECT_NAME = 'PRC_MINE'
0
If you are interested in actual changes 2 to the code, look into the AUDIT statement 1 or a DDL trigger
Maybe it is better to use something like 2 sub version or team system to handle source 1 control.
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.