Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL
If you're running 8.1.5 you can use native
dynamic SQL. It's faster and easier to use, with
some minor limitations compared to the DBMS_SQL
package that don't impact your example. You can
find it in the Oracle documentation and it's only
about 10 pages of reading...
Example:
declare
begin
Simple enough?
Michael J. Ort
In article <38EB7980.D3636A99_at_lvvwd.com>,
Kyriakos Lambros <kyriakos.lambros_at_lvvwd.com>
wrote:
> Does anyone know where I can find good
documentation on dynamic SQL?
> Specifically I am trying to create and drop a
table via a pl/sql block.
>
> Thanks,
>
> Kyriakos Lambros
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Apr 07 2000 - 12:31:43 CDT