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.
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.
Previous Topic: FRM-21011 & ora 6502
Next Topic: validation code required
Goto Forum:
  


Current Time: Sat Dec 03 22:02:22 CST 2016

Total time taken to generate the page: 0.13691 seconds