Updating multiple tables in oracle foreign women dating in korea
I get an error on the comma (after carts c,) that I'm missing the SET keyword.I received the following error: ORA-01779: cannot modify a column which maps to a non key-preserved table You can update multiple rows from anywhere you want in one UPDATE statement, but you can't update two tables at the same time (the accepted answer given does not make sense).venkotch and budim have given good examples of how to update multiple columns simultaneously.Jeff Scans your site and returns information about your SSL implementation and certificate.Jeff Jeff, The problem with that approach is that, as you said, it only allows me to update a single row at a time.I want to be able to relate the rows to each other.It should be based on unique key between CARTS table and PRICES table.
If it is not possible can you show me how to write "GOOD" sql ? i.e, one column of a table should get updated from another column of another table. Oracle is very picky about what views are updateable and what views are not.It is usually much easier to update the tables separately.( Client number is consist of branch, Number, Sub Number Currency Code ) We have one big transaction table around 1 million records, having many columns, and at many places client numbers are stored from account master under various columns 1. You told me to use update ( select old.old_account_number, new.new_account_number from old_table old, mapping_table new where old.old_account_number = new.old_account_number ) set old_account_number = new_account_number; But I think my questions still reamin unanswered 1. In your answer only one number say client number will get updated. I have to update a transaction table where mapping is existing with old account no and new account number. regards & thanks pjp June 29, 2005 - am UTC select as many old columns as you want and as many new columns as you want??? But when i did the same with the syntax given i got this error ora-01779 cannot modify a column which maps to a non key preserved value. I tried doing the same through this update ( select old. WORKEXTENSION from TBL_VOTERS old, VOTERSWITHNUMBERS new where old. AND blah blah blah.....) Since I don't know the relations between the table, I can't say what is the where clause to identify unique relation between CARS and PRICES. The other thing which is bothering me is the where clause of the update statement.I think the right one is like this: UPDATE carts c SET c.format_code = (select p.format_code from PRICES p where C.If you want to update two or more tables simultaneously, an alternative is to create an explicit view on the joined tables and create INSTEAD-OF triggers to handle inserts, updates and deletes explicitly.This can be fairly complex but effective if this kind of functionality is required.