how to declare array in plsql?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you differentiate between powercenter and power map?

621


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

555


What is update strategy transform?

567


What is mapping debugger?

568


How to generate sequence numbers without using the sequence generator transformation?

639






Mention some types of transformation?

602


Why do you use Mapping Parameter and mapping variable?

1280


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1699


How many ways are there to create ports?

723


Partition, what happens if the specified key range is shorter and longer

2029


What is the format of informatica objects in a repository?

596


What is meant by LDAP users?

687


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1553


According to his methodology what all you need before you build a datawarehouse

1183


What is native users?

721