Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create or Replace Table

MeeuwtjeMay 30 2016 — edited May 30 2016

A table you first have to create it.

Then you can alter it.

But in a development/test/production environment this is not always practical.

Since you may want to change something of a new table before it goes to production.

You can use PL/SQL to avoid installation errors:

If the table doesn't exists, then do create.

If it does exits, then do an alter.

It makes a table script more complex.

So it would make our developers life much easier if it was possible to have the table syntax:

create or replace table XXXX

(...);

Comments
Post Details
Added on May 30 2016
10 comments
13,120 views