"RETURNING...BULK COLLECT" - code check

From: klabu <noone_at_gmail_dot_com>
Date: Tue, 14 Nov 2006 22:27:46 -0500
Message-ID: <12ll29jk38k6j72@corp.supernews.com>

Code below works but
But is Line#5 "RETURNING ...BULK COLLECT" "legit" usage/syntax ? I just want assurance
thanks

SQL> DECLARE

  2          TYPE typ_tab_empno IS TABLE OF myemp.empno%TYPE;
  3          l_tab typ_tab_empno ;
  4  BEGIN
  5         UPDATE myemp SET job = 'COMEDIAN' RETURNING empno BULK COLLECT 

INTO l_tab ;
  6 END;
  7 /

PL/SQL procedure successfully completed

-- 
10gR2 

Received on Tue Nov 14 2006 - 21:27:46 CST