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 |
On which transformations you created partitions in your project?
what is the difference between informatica6.1 and infomatica7.1
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is persistent lookup cache?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
whether Sequence generater T/r uses Caches? then what type of Cache it is
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.
Explain the different dimensions.
When you move from devel to prod how will you retain a variable
What is session task and command task?
How the informatica server increases the session performance through partitioning the source?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,