It is often necessary to revert to a previous version if several people modify the stored procedure. Then you can use the following query. However, it is only possible with sufficient authority.
SELECT TEXT
FROM ALL_SOURCE AS OF TIMESTAMP TO_TIMESTAMP ('20180404', 'YYYYMMDD')
WHERE NAME = 'SAMPLE_STORED_PROCEDURE' AND TYPE = 'PROCEDURE';
This will retrieve the April 4, 2018 version of the procedure.
Congratulations @south-man! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
To support your work, I also upvoted your post!
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOPDo not miss the last announcement from @steemitboard!