Insert into new column - Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Insert into new column - Urgent

  1. #1
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi there, urgent help please

    I have added a new column to a table using

    alter table T_LINES add
    (LINE_CODE VARCHAR2(5));

    I now want to populate the column, I have tried

    INSERT INTO T_LINES (LINE_CODE) VALUES ('NH1')
    WHERE LINE_KEY = 0;

    But it keeps coming back with an error,

    It's Oracle 8i on Window NT

    Thanks

    Alison

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    what you want to do is an update, not an insert !!!

Posting Permissions

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


Click Here to Expand Forum to Full Width