Pergunta de entrevista da empresa IBM
You are developing a PL/SQL block designed for bulk data operations. When attemping to store table data for multiple rows in a PL/SQL variable, which one of the following choices identifies the mechanism best suited for this task (choose one)? A. cursor B. varchar2 C. record D. table of records
Resposta da entrevista
Sigiloso
16 de nov. de 2010
Answer is D. We need multiple rows on a variable so we use here Table of records .it uses just like as collection of records. Cursor is used for selecting multiple rows from stored table. Varchar stores only single value. Record used to store a single row thus for store multiple rows on a variable use Table of records