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 INTO in LOOP

694243Apr 14 2011 — edited Apr 14 2011

Hello,

isn't it possible to use the select into in a loop block?

for c_record in c_all_records loop
  select count(*)
  from table_1
  where tbl1_id = c_record.col_id;
end loop;

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2011

Added on Apr 14 2011

8 comments

10,414 views