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 is workflow varible
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What is IQD file?
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?
What are differences between Informatica 7.1 and 6.1
What is Collect performance data in informatica and what is the use of it.
Describe two levels in which update strategy transformation sets?
how i will stop my workflow after 10 errors
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
what is pre and post sql and what is diff between source presql and target pre sql
What is the session task and command task?