Re: Can i use CREATE TABLE, CREATE VIEW etc. in PL/SQL Block of package?
From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Tue, 17 Jul 2001 14:58:48 +0400
Message-ID: <9j15et$c1n$1_at_news247.cnt.ru>
Date: Tue, 17 Jul 2001 14:58:48 +0400
Message-ID: <9j15et$c1n$1_at_news247.cnt.ru>
Hello!
You can create table,view, etc. in PL/SQL block using either "EXECUTE
IMMEDIATE ..."(Oracle 8i) or using dynamic SQL.
Best regards!
Yaroslav.
Kevin <factor_at_mail.ru> ñîîáùèë â íîâîñòÿõ
ñëåäóþùåå:eb7b37e9.0107170141.1e0e5d0b_at_posting.google.com...
> Hello all!
>
> I need to create a table in one PL/SQL block, composed in package.
> Can i use CREATE TABLE, CREATE VIEW etc. in PL/SQL Block?
> When i trying to use, i see the error message.
>
> Kevin, Russia.
Received on Tue Jul 17 2001 - 12:58:48 CEST