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

what are presession,postsession success and postsession failure commands ?

1 Answers  


What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,


Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,


task is running successfully but data is not loded why?

2 Answers  


what is correlated query?

2 Answers   IBM,






Target increases every day even though no new record was inserted

0 Answers   Accenture,


What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,


how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,


If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  


what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,


How to improve the session performance in informatica?

3 Answers   Accenture,


How we can use union transformation?

0 Answers  


Categories