Adding column.

[dba_dada]

Oracle 8.0.5
--------------

Is it possible to add a new column in a table (where data already exists)?


Col1
Col2

And I want to put in a new column between Col 1 and Col 2.

How?


[Edited by dba_dada on 06-27-2002 at 09:47 AM]

[jovery]

You can add a column using the 'alter table...' command but you cannot specify where the column will go. It is always appended to the end of the table.

Regards

[marist89]

Another chrisrlong opportunity...

The position of the columns in a relational structure is totally irrelevent. If your design is dependant on the order of the attributes, your design is wrong.

[Mr.Hanky]

I hate to give any YANNI fan credit but Jeff has a good (if not borrowed) point.

MH

[dba_dada]

Mr.Hanky


What are you talking about?????????? What YANNI fan got to do with Adding column??????

If you don’t have a solution…just don’t bother to reply….
----------------------------------------------------------------

Jeff:

Thanks. You are right, bad Design.

But we didn’t design it, just inherited from the previous contractor…



[Edited by dba_dada on 06-27-2002 at 11:20 AM]

[JMac]

Would there not be an argument for it when you are adding a new NOT NULL column? Aren't we supposed to have all NOT NULL columns at the 'head' of the table, followed by the optional ones? Seem to remember this from a while back.

[raghud]

It is possible

it you got table test
row1
row2

create table test1 ..Here is syntax ...

create table test1 as select row1,' ' dum,row2 from test;

then drop test ..Rename test1 as test ;

[Mr.Hanky]

Originally posted by dba_dada
Mr.Hanky


What are you talking about?????????? What YANNI fan got to do with Adding column??????

If you don’t have a solution…just don’t bother to reply….
----------------------------------------------------------------


[Edited by dba_dada on 06-27-2002 at 11:20 AM]

How bout I loan you a quarter so you can run out and buy yourself a sense of humor?

BITE ME!!

MH

[dba_dada]

You are doing exactly what I ask you not to do....

Grow up!

[Mr.Hanky]

Originally posted by dba_dada
You are doing exactly what I ask you not to do....

Grow up!

I know you are but what am I?