Home » Other » General » Data Modification on Personal Orcale 7
Data Modification on Personal Orcale 7 [message #197770] Thu, 12 October 2006 10:49 Go to next message
yllee
Messages: 1
Registered: October 2006
Junior Member
Hi,

I have a database which running on Personal Oracle 7. The database is on going and live. Now, I want to modify my item code. Is it any way/utility able to change particular item code in all tables in one time?
For example, I want to change item code 1002 to 1112. The item code 1002 has been use for many transactions. Manual edit is not possible because of key and link problem. So, I want look for a code/utility which be able to change the item code in all table accordingly, no matter there is key/link issue.

Please help.

Thanks & Regards

Re: Data Modification on Personal Orcale 7 [message #197831 is a reply to message #197770] Thu, 12 October 2006 19:41 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
It sounds to me like you will have to write custom SQL to create new records with the new value in those tables that use the field as a primary key. Then update the subordinate table entries and then delete the old primary records.

David
Previous Topic: Failure to enlist in resource Manager
Next Topic: Trial Oracle software?
Goto Forum:
  


Current Time: Thu Dec 08 10:36:18 CST 2016

Total time taken to generate the page: 0.07700 seconds