load record with two row types using bulk collect.
Hello,
Can someone tell me how to load two row types at one time using bulk collect and how to reference them?
My table structures are identical, the difference is that tableb is going to be a historical table.
First I'll check if a column in the first table is different in the second table if the join id columns are the
same.
If the ids are the same, check if one particular column(code_marker) has changed, if it has changed then update the
whole record in tableb. If the the id is not found in the tableb then insert the record. I know this sounds like
Can someone tell me how to load two row types at one time using bulk collect and how to reference them?
My table structures are identical, the difference is that tableb is going to be a historical table.
First I'll check if a column in the first table is different in the second table if the join id columns are the
same.
If the ids are the same, check if one particular column(code_marker) has changed, if it has changed then update the
whole record in tableb. If the the id is not found in the tableb then insert the record. I know this sounds like
0