Home » RDBMS Server » Server Administration » How to add new column to a already available table?
How to add new column to a already available table? [message #374506] Fri, 15 June 2001 07:54 Go to next message
Celia Tamilarasi
Messages: 1
Registered: June 2001
Junior Member
hi all,
pls. help me how to add a new column to a table created already and fed with data.

thanks,
celia

Report message to a moderator

Re: How to add new column to a already available table? [message #374521 is a reply to message #374506] Fri, 15 June 2001 18:26 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
If the table already has data, then the new column(s) will start off NULL, you can make them NOT NULL afterwards.

Alter table XYZ add(ABC varchar2(10));

update XYZ set ABC = 'Hello';

alter table XYZ modify (ABC not null);

Report message to a moderator

Previous Topic: delete a column from a table
Next Topic: Selecting an alpha character from a varchar2 field containing mostly numbers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 18:09:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.