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';

Hi

Your script should update the record assuming the ID and name exist. Try a commit after the update to save the change.

UPDATE table_one
set ID=replace(ID,'&ID','&ID')
where Name='&Name';
commit;
select * from table_one; -- will show your change

Don't perform the update in one sqlplus window and try and view the results in another as the results won't show until you've issued a commit statement.

Hope it helps.

Merry Christmas
Alistair

To do 2 updates or more you only have to add your lines to the script. But be sure to make a commit at the bottom as alit2002.

You can add as many querys as you need.

If you have just inserted data, then you may need to put a commit after every query.

Hope it helps

once you COMMIT that will be reflected in the database table.

if you exit without commit all the uncommitted transactions will be rolled back.

I was just reading your code and I have a question:

Are the variables names ok?
Maybe you need to name the 'ID' vars different. IDo and IDn for example.

Maybe the problem with the update is that the 'replace' cannot do his job.

If that is an errata...well... try with SO parameters.
Hope it works.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.