SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select column values into collection

AbhiShahMay 6 2013 — edited May 6 2013

Greetings,

I want to select column values into collection(plsql tables or array) like following code, could it be possible
here tt is any collection

select emp_no, name, dob, sal into tt(1),tt(2),tt(3),tt(4) from emp; -- single row query

select dep_no, name, doj, stength into tt(5),tt(6),tt(7),tt(8) from emp; -- single row query

VERSION
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production

Thanks in advance

This post has been answered by Karthick2003 on May 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2013

Added on May 6 2013

11 comments

819 views