Re: Oracle Scripting Question

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 18 Nov 2003 10:40:01 -0800
Message-ID: <1069180823.955161@yasure>

DTS wrote:

> Regarding...
>
>

>>>-Can I embed SQL DML statements inside of PLSQL blocks? 
>>
>>That is what they are there for.

>
>
> I meant to say DDL statements, not DML statements. Perhaps the
> question is just as trivial though. Looking forward to your response!
> Thanks for all of the other great feedback!

Not directly. You must use native dynamic SQL or the DBMS_SQL package.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Nov 18 2003 - 12:40:01 CST