Re: Create table & DML from triger

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 17 Apr 2001 18:22:44 +0200
Message-ID: <2drodt4g2fat7k55v8qfc2ngc95m2duaok_at_4ax.com>


[Quoted] On Tue, 17 Apr 2001 12:19:09 +0200, "Moshe" <mieczyslaw.pawlowski_at_koma.com.pl> wrote:

>Hi Everyone
>
>Forms 6i, I would like to create table and fill it. I see that I can't use
>"create table", "drop table", "rename aa to bb" and also "insert" in
>When-button-presed. How can I do it.
>
>Regards Moshe
>
execute immediate '<sqlcommand>'

however, if guess your DBA would have a serious problem with your on the fly table creation.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Apr 17 2001 - 18:22:44 CEST

Original text of this message