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]
Printable View
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]
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
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.
I hate to give any YANNI fan credit but Jeff has a good (if not borrowed) point.
MH
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]
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.
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 ;
How bout I loan you a quarter so you can run out and buy yourself a sense of humor?Quote:
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]
BITE ME!!
MH
You are doing exactly what I ask you not to do....
Grow up!
I know you are but what am I?Quote:
Originally posted by dba_dada
You are doing exactly what I ask you not to do....
Grow up!