Andy Hassall wrote:
> 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.
I could have added TRUNCATE too but I don't do that very often in a
production app.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon May 16 2005 - 12:51:23 CDT
