|
|
Re: How to enable editing in Toad [message #417728 is a reply to message #412564] |
Tue, 11 August 2009 05:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Well, you could open Schema Browser, navigate to a table you are about to update, set filter (unless you want to update all records - there might be millions of them) and overtype old values to new ones.
You can expect problems, such as violation of different constraint types (uniqueness, non-existent values in foreign key relationships etc.) and, most of all, the fact that changes you commit are irreversible. You don't know previous values any more, and, if you aren't careful enough, you may even lose records you have updated from sight (for example, navigation to a different table and return back into the updated one might display nothing because filter doesn't see these records any more as you've updated these values).
Manually written UPDATE statement leaves a track (you know what you've updated and where). Your way ... well, is risky. Do you want to take that risk?
|
|
|
|