Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Posts
    2

    Post Unanswered: how to enter data in a new column of existing table

    hello
    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.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    You are looking for the UPDATE statement, not the INSERT statement

  3. #3
    Join Date
    Jan 2009
    Posts
    2

    thanks for ur kind help

    hello sir/shammat

    its manish here
    i really wanna to thank u for solving my query..
    really thanks very much....for ur kind help.

    manish kumar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •