re: 3 Latest version of a Package

Tejas Jadhav

re: 3 Latest version of a Package

Hello Friends,

Brief backgroud : This is for maintaining Plan_Table to only have access path for 3 latest versions of A package and older  are archived
                          to plan_Table_hist.

I'm looking for SQL / way to find 3 latest version A packages from the PLAN_TABLE .
I will appreciate help in this. Thanks !!

Cheers,

Tejas Jadhav