Updating two different tables with cursor oracle

Table Name AS tb Name FROM DBC.Hi Tom, Due to migration to new system we have to change all our account numbers. June 28, 2005 - pm UTC yes, the predicate in the join for the fictional question without a sample table and data was wrong (everytime I wing it, try to answer WITHOUT TESTING, it comes out wrong. test cases are relevant :) Hi Tom, Thanks for answering my question. But Sales Supplier, Purchase supplier, Wholesale Supplier ..many other columns how can i update in single SQL ( I have to update around 70 columns and some columns may have null values such as Purchase supplier ..) 2. You need to have the table you are updating from have a unique or primary key constraint. Secondly you have shown me to update table with "KEY PRESERVED" method. IT NEEDS THIS LOGICALLY regardless of the method used, so just add it (for if a row in OLD joins to more than one row in NEW -- you are hosed, you cannot update this data, therefore NEW has a unique/primary key, add it to facilitate the update) I had a similiar query and i tried applying to my tables. I tried something like code below, using 'LOOP' and cursor, but it says that DECLARE cursor_Tables CURSOR FOR SELECT Database Name '.'

Leave a Reply

  1. speed dating in newcastle uk 28-Mar-2020 10:02

    These are the secret emoticons that are not in the Skype menu, type them directly in the chat box to use them: with the code of the country whose flag you want to display.

  2. dating rules in your forties 04-Jan-2020 23:39

    If you’re worried about tomorrow and how it might compare to yesterday, buy a Porsche 911 – it’s not gonna change radically anytime in the next million years.

  3. hooking up and dating 25-Jan-2020 05:31

    Posted: , Author: Bemep When sun dating phenome I say really, I mean really.

  4. Darect on line statar 30-Dec-2019 20:42

    Now we, this generation, are opening them one by one. Well, yes, with a few women at a time, but who hasn’t done that?

  5. shia labeouf and megan dating 18-Jul-2020 01:02

    Now you can get something good and do something good at the same time.