Updating Rows 1

[Tepzepi]

Hi everyone

I'm brand new to SQL, trying to learn this fascinating language.

I am required to run this script via SQL plus to Oracle 7.3 DB.I did not write it, but it is not producing desired results. So I want to correct it.

The following does not change the 2 usr_inhibited MALANCO01 & TAINTO01 back to -1. Please advise how to correct.



REM this line uninhibits all users
update usr_user set usr_inhibited = '0' where usr_inhibited = '-1';

REM This line inhibits selected users
REM update usr_user set usr_inhibited = '-1' where usr_userid = 'MALANC01';
REM update usr_user set usr_inhibited = '-1' where usr_userid = 'TAINTO01';

COMMIT;


Thanks in advance.

I'd rather be stupid for 5 minutes than for the rest of my life.

 

[karluk]

Please forgive the obvious suggestion, but it looks as if you have the statements commented out. Try removing the "REM" from the two update statements and they should execute.

 

[Tepzepi]

Thanks karluk, obvious to you, not to me. I appreciate you taking the time to post a reply.

Regards,

I'd rather be stupid for 5 minutes than for the rest of my life.