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 |
what are presession,postsession success and postsession failure commands ?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
Can we insert ,update ,delete in target tables with one update strategy tran.?
task is running successfully but data is not loded why?
what is correlated query?
Target increases every day even though no new record was inserted
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
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..?
what are the challenge face in u r project?explain me
How to improve the session performance in informatica?
How we can use union transformation?