Unanswered: how to enter data in a new column of existing table
actually i am very new in database and now i am using sql-plus from oracle 9i. i have a table named as student which has three columns named with statement. create table student (name (varchar(15), rollno(number(5), class(varchar(10));
the i have inserted values in the first row of the table as per the datatypes using insert into statement.
after that i have altered the table and add a new column named fee using the statement alter table student add (fee number(5);
but now on insertion a value in fee column inserts it to 2nd row but i want to insert the value in the first row(because the value of fee is still blank in first row) under fee column. how it is possible please send me the full qurey for that.