-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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.
Jeff Hunter
-
I hate to give any YANNI fan credit but Jeff has a good (if not borrowed) point.
MH
I remember when this place was cool.
-
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 ;
Raghu
-
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
I remember when this place was cool.
-
You are doing exactly what I ask you not to do....
Grow up!
-
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?
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|