On Apr 21, 1:09 pm, "Rob Wolfe" <rob.wo...@oraclegeeks.com> wrote:
> On Tue, April 21, 2009 11:59, student4life wrote:
>
> > could someone inform me how one can tell/differentiate whether a
> > completed transaction was update or delete ? (for example, SQL
> > %ROWCOUNT does NOT differentiate the two). TIA
>
> I think you have lost me completely. Can you give a concrete example of
> when you would foresee needing to do this along with a short code snippet
> showing what you mean?
>
> Rob

For example,

 (1)   delete from a where b = c;

    if(SQL%ROWCOUNT > 0) then
        DBMS_OUTPUT.PUT_LINE('delete successfully ...' );
    end if;

(2)    update a set b = d where b = c;

    if(SQL%ROWCOUNT > 0) then
        DBMS_OUTPUT.PUT_LINE('delete successfully ...' );
    end if;


Is it possible to use only 1 if statement instead of 2?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to