I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates simultaneously. Thanks. Here is the code
accept ID prompt 'Enter Old ID:'
accept ID prompt 'Enter New ID:'
accept Name prompt 'Name:'
UPDATE table_one
SET ID=REPLACE(ID,'&ID','&ID')
WHERE Name='&Name';
Last edited by joshmo; Nov 16th, 2008 at 8:45 am.