OCI 8 stage

[kollurianu]

Hi all,

In OCI stage can i write a user defined query for update , and

update few feilds in the table , and also update key and table primary

key is different , but the update key would be unique.

any inputs most appreciated.

Thank you all very much.

[Bala R]

Certainly can do. But verify whether the integrity of the underlying table is not broken when you update the key field itself.

[kcbland]

Any usage of that primary key as a foreign key needs to be handled. If you have a parent-child relationship with tables, you shouldn't have orphans after you change the primary key value.

Are you sure this is what you need to do?