1. Version control system: If your stored procedures are managed by a version control system (such as Git, SVN, etc.). ), you can find the update history of stored procedures through the records of the version control system. The version control system will record every submitted change, including the modification of stored procedures.

2. Database log: The log files in the Oracle database (such as archive log and redo log) record all the operations of the database, including the updates to stored procedures. You can query the log file of the database to find the update records of a specific stored procedure. This method requires a certain understanding of the structure and query method of Oracle database logs.

3. Built-in tables and views: Oracle database provides some built-in tables and views, which can be used to find the metadata information of objects, including the update time and updater of stored procedures. For example, you can query the ALL_OBJECTS table or DBA_OBJECTS view, filter out stored procedures according to object types, and find relevant update information.