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

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,


What is persistent lookup cache?

0 Answers  


HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,






whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,


Explain the different dimensions.

0 Answers  


When you move from devel to prod how will you retain a variable

1 Answers  


What is session task and command task?

0 Answers  


How the informatica server increases the session performance through partitioning the source?

1 Answers  


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


Categories