Re: Dynamice SQL in Oracle

On Sun, 15 May 2005 08:55:00 -0700, psoug <damorgan_at_psoug.org> wrote:

>> Anyway, how can you separate out "DDL in EXECUTE IMMEDIATE" from "creating,
>> altering and dropping objects using PL/SQL" - doesn't leave much?
>
>GRANT and REVOKE.

 Ah, fair point, didn't quite think of them as "Data Definition Language" since they don't define or change any data structures, just change access to objects. But they certainly act like DDL statements.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool