Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 is workflow varible

1 Answers   HP,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,


What is IQD file?

1 Answers  


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


What are differences between Informatica 7.1 and 6.1

3 Answers  


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


Describe two levels in which update strategy transformation sets?

1 Answers  


how i will stop my workflow after 10 errors

1 Answers   HP,


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,


State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  


what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,


What is the session task and command task?

0 Answers  


Categories