RE: full usefulness of CURRENT OF ???

[Mercadante, Thomas F]

Title: RE: full usefulness of CURRENT OF ???

this is better than using rowid in the update clause????

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: full usefulness of CURRENT OF ???

Try with a complicated where clause where your where_clause is a page long ...

Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: Maryann Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: full usefullness of CURRENT OF ???

Could anyone give us an idea as to the full usefullness
of CURRENT OF?  Here are my two separate examples:

/*   1  this one has a CURRENT OF  */

DECLARE

    CURSOR  EmpCursor  IS
            SELECT  *
            FROM    Emp
            FOR     UPDATE;

BEGIN
     FOR EmpRec IN EmpCursor LOOP

         UPDATE EMP
         SET    SALARY = SALARY * 1.08
         WHERE  CURRENT OF EmpCursor

     END LOOP;

END;

/*   2 same as above, except without the CURRENT OF   */
DECLARE

   CURSOR  EmpCursor  IS
           SELECT  *
           FROM    Emp
           FOR     UPDATE;

BEGIN
     FOR EmpRec IN EmpCursor LOOP

         UPDATE EMP
         SET    SALARY = SALARY * 1.08
         WHERE  EMP_ID = EmpRec.Emp_ID;

     END LOOP;

END;
/

Is one more efficient than the other? If I could have done
business without the CURRENT OF, then why did oracle made
it available?

thx
maa

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maryann Atkinson
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).