solution?

[wgdesigner]

If iam making a table of location in that table i have columns city,county,condition. And i had some values added in these columns.. after addeding the values in these three columns now i want to add the new column temperature by alter table location add(tempareture number(2)); but i want to add the values from start in this new column how that is possible is that possible for 1st column value as follow.. insert into location(tempareture) values(34) where city='Athens'; like that in other columns i can put the value tempareture???? please tell me solution.. Raj Khatri

[Hesham Amin]

seems you need to update not to insert update location set tempareture=34 where city='Athens';