Re: 10g recycle bin and ALL_OBJECTS
Date: Mon, 04 Feb 2008 15:28:16 -0800
Matthias Hoys wrote:
> "Harel" <guhar1_at_yahoo.com> wrote in message
>>> dba_recyclebin view lists the objects in recyclebin. >>> Exclude those >> Ok. But then my utility would have to create two cursors, one if I am >> Ora 9 , and one if Ora 10 and +. >> Tornicated.
> Check if dba_recyclebin exists ? Or code the database version in your
> utility ?
> if (ora9) then
> end if;
Why reinvent the wheel? Just use the built-in compiler flags. http://www.psoug.org/reference/dbms_db_version.html
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Feb 04 2008 - 17:28:16 CST