Hi All,
Here is the scenario, Please help me with possible solutions.
Have 2 system. Source and Target.
After comparing data of source system with the target system, a temporary
table is populated with values like the below.
*Table_name* *Column_name* *Column_value* *T_NUM* T1 C1 V1 1 T1 C2 V2 1
T1 C3 V3 1 T1 C4 V4 1 T1 C5 V5 2 T1 C6 V6 2 T1 C7 V7 2 T1 C8 V8 2
*T_NUM is the column to restrict.*
I need to update T1 like below using the example data above.
Update T1(C1, C2, C3, C4)
values(V1, V2, V3, V4)
where T_NUM = 1;
Update T1(C5, C6, C7, C8)
values(V5, V6, V7, V8)
where T_NUM = 2;
Please let me know an efficient way of doing this, as the data volume is
big.
Thanks in advance
G
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
