Ad:

Oracle Discussion Thread
Unsolved
Views: 1759

Nov 16th, 2008

problem with update

Expand Post »

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

Oracle Syntax (Toggle Plain Text)
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';
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.

Similar Threads

Error 624: The system could not update the phone book file in Windows NT / 2000 / XP
Problem with Windows Update and WinXP in Web Browsers
help!! update mysql problem in MySQL
Not able to change/update password in PHP
Page Cannot Be Displayed Problem PLEASE HELP in Troubleshooting Dead Machines

joshmo

Reputation Points: 19

Solved Threads: 20

Posting Whiz in Training

Offline

280 posts
since Oct 2007

Permalink

Dec 24th, 2008

Re: problem with update

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

alit2002

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

52 posts
since Dec 2006

Permalink

Mar 6th, 2009

Re: problem with update

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

vimotaru

Reputation Points: 11

Solved Threads: 1

Newbie Poster

Offline

17 posts
since Oct 2008

Permalink

Mar 9th, 2009

Re: problem with update

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

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

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Permalink

Mar 10th, 2009

Re: problem with update

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.

vimotaru

Reputation Points: 11

Solved Threads: 1

Newbie Poster

Offline

17 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: Limit days stored in DB

Next Thread in Oracle Forum Timeline: update a record on load

DaniWeb Message

Cancel Changes

User Name
Password