| Data Modification on Personal Orcale 7 [message #197770] |
Thu, 12 October 2006 10:49  |
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
