RE: What is the result of this

> -----Original Message-----
>
> It will stack the call and use more and more resources, check
> the size of
> the session PGA.
> You can do recursivity with SQL.

I'm fiddling with it. The thing I originally sent was just a skeleton idea. After putting a little meat on the bones, it doesn't seem to be problem in the test database (of course, everything always works in the test database). One thing I discovered is that I can't run it as system to drop the index from bubba's schema. It always says the index does not exist. It doesn't like the BUBBA.INDEX_NAME. I have to run it as bubba and drop INDEX_NAME. I've not checked the PGA size while it was running; I'll see about doing that.

>
> Jared, you should ask about recursivity with SQL in your interviews.
>

And ask about the usefulness of the command rm -rf *

(especially when run in the / directory)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).