Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How i can alter a table into a script ?

Re: How i can alter a table into a script ?

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 30 Jul 2001 11:58:27 -0700
Message-ID: <3B65AE53.70B90399@attws.com>

Fabio Dell'Aria wrote:

> Please can you tell me abaut the object.
>
> How i can alter a table into a ORACLE script ?
>
> Please write me some exaples.
>
> --
> Best regards...
>
> Fabio Dell'Aria
>
> E-mail: thesun_at_inwind.it

Use native dynamic SQL.

EXECUTE IMMEDIATE 'alter table ....';

Daniel A. Morgan Received on Mon Jul 30 2001 - 13:58:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US