SQL & PL/SQL

Hi All,

DECLARE

v_count number;

BEGIN

UPDATE customer_dup SET cid = 95 WHERE cno = 'C1222';

v_count:= SQL%Rowcount;

DBMS_OUTPUT.PUT_LINE('count is ' ||v_count);

END;

If I use the statement v_count:= SQL%Rowcount

then I could able to see the updated value from other session.

If I am not using v_count:= SQL%Rowcount  unable to see the updated value from other session.

Please let me know how SQL%ROWCOUNT works.Is it internally issue commit.

Thanks in advance.