how to declare array in plsql?



how to declare array in plsql?..

Answer / nagaraju bhatraju

DECLARE
TYPE v_arr IS VARRAY(25) of NUMBER(3);


v1 v_arr;

v_empno employee.empno%TYPE;

BEGIN

v1(2) := 3;
DBMS_OUTPUT.PUT_LINE('The Value of v1(2) = ' || v1(2));

v_empno := 4;

END;

Is This Answer Correct ?    13 Yes 17 No

Post New Answer

More Informatica Interview Questions

How to implement security measures using repository manager?

0 Answers  


Please let me know how to make encryption and decryption with example?

0 Answers  


What does command task mean?

0 Answers  


how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,


what is left outer join?

3 Answers   L&T,


Can i create a lookup table without cache.

7 Answers   iGate,


what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,


Write the prerequisite tasks to achieve the session partition?

0 Answers  


How to recover sessions in concurrent batches?

1 Answers  


How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,


Explain the difference between a data warehouse and a data mart?

0 Answers  


i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


Categories