DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: multiple columns update

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    Is there a way to get around this problem? I am trying to update multiple columns in the same 'update' statement without using a subquery.
    update /table_name/
    set (column_name, column_name)=(value, value);
    ERROR at line 2:
    ORA-01767: UPDATE ... SET expression must be a subquery

  2. #2
    Join Date
    Sep 2000
    Posts
    4
    Try this way,
    update test set c2=2,c3=3 where c1=1;

    thanks
    anand

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