RE: adding col in between....

Maybe the 'why' question can be answered. I was involved in a project, where all queries were 'select * from.....'. And all updates updated every single column, of course, whether the contents changed or not.

Yes, it was Java. They 'generated' the SQL, and required all columns to be in alphabetical order.

So, every table got recreated when columns were added. And columns got added almost daily, during the development phase. There was no predesigne data model, it grew organically, every day, when an XtremeProgrammer needed some 'fields' to store 'something'.

Althought this explains why one would do this, it still doesn't make any sense.
No surprise they got -some- performance problems.... Let alone the burden of deployment of new releases, with a minimum of downtime.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Tue, 2005-07-19 at 11:15, Lex de Haan wrote:

> ... and the counter question is: why would you ever want to do this?
> this is highly un-relational, because column ordering is supposed to
> be meaningless.
> well, let me answer your question anyway: in Oracle, there is no
> direct way to accomplish this.
> check out the DBMS_REDEFINITION package -- that will do the job for
> you, if you insist :-)
>
>
> cheers,
>
> Lex.
>
> ------------------------------------------------------------------
> Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
> ------------------------------------------------------------------
>
>
>
> ______________________________________________________________________
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary
> Sent: Tuesday, July 19, 2005 07:39
> To: oracle-l_at_freelists.org
> Subject: adding col in between....
>
>
> hi all,
>
> Is it possible to add a new column in the between of table. For ex.
> Say there is a table as
>
> col position col name
> 1 ID
> 2 Name
> 3 Address
>
> I have to add a col. after NAME col and before ADDRESS col. Is it
> possible ? how ?
>
> TIA
>
> --
> Thanks & Regards,
> T. Onkar Nath
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>

--
http://www.freelists.org/webpage/oracle-l