Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. I need to update one of the tables in my the Database with random values, so that I have written multiple update statements but its taking a lot of time for execution, I need to update only 15 columns in the table containing of Columns.
I have 15 columns to update. I have written with ID number of the column to be update with the variable value field. If you have many rows that do not satisfy the conditions, adding a where condition could speed up things. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. So I'm afraid what you need to do is this:. Perhaps that seems a bit clunky to you. It is, but the problem lies in your data model.
Storing derivable values in the table, rather than deriving when needed, rarely leads to elegant SQL. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. Search BC Oracle Sites. Updates based on two or more common columns are normally used for tables where multiple columns work together as a primary key known as composite primary key.
These columns uniquely identify a record in a table. Happy updating! Get single records when duplicate records exist 2. Find duplicate values or non-duplicate values in a table 3. How the data types in Access Northwind are converted to Oracle 6.
All Rights Reserved.
0コメント