How to Recover Dropped PACKAGE, PROCEDURE OR FUNCTION.

This might happen to anyone who are developing a code, there might be chances that you accidentally dropped your code or accidentally overwritten the code.

Oracle has provided various flashback features through which you can recover your code.

Now let us see how to recover your code.

I have created a sample function as shown below.

CREATE OR REPLACE FUNCTION APPS.FLASHTEST

RETURN DATE

IS

result DATE;

BEGIN

result:=NULL;