Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

"RETURNING...BULK COLLECT" - code check

2 views
Skip to first unread message

klabu

unread,
Nov 14, 2006, 10:27:46 PM11/14/06
to
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


DA Morgan

unread,
Nov 19, 2006, 12:55:41 PM11/19/06
to

Did you try it?
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

klabu

unread,
Nov 20, 2006, 4:01:43 PM11/20/06
to

"DA Morgan"

> Did you try it?

Yes

"> Code below works but.."

Just want some assurance ;)


DA Morgan

unread,
Nov 20, 2006, 7:57:51 PM11/20/06
to

Assurance or insurance? <g>

0 new messages