Home » Developer & Programmer » Forms » update statement
update statement [message #328401] Fri, 20 June 2008 01:27 Go to next message
shahnirav86
Messages: 13
Registered: June 2008
Location: anand,gujarat
Junior Member
i am using form 6i,database oracle 7i
i have requirement like how many rows is updated when update statement fires in pl/sql block;
i need to know how many rows is update.

Report message to a moderator

SLOVE : update statement [message #328413 is a reply to message #328401] Fri, 20 June 2008 01:57 Go to previous message
shahnirav86
Messages: 13
Registered: June 2008
Location: anand,gujarat
Junior Member
NOW I HAVE ANSWER OF THIS QUESTION
1 DECLARE
2 BEGIN
3 UPDATE TMP SET TMP_FIELD1='1';
4 DBMS_OUTPUT.PUT_LINE('YOU ARE UPDATE '|| SQL%ROWCOUNT||' ROWS');
5 COMMIT;
6* END;
7 /
YOU ARE UPDATE 20 ROWS

PL/SQL procedure successfully completed.

Report message to a moderator

Previous Topic: FRM-21011 & ora 6502
Next Topic: validation code required
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 16 15:30:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.