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 |
How to implement security measures using repository manager?
Please let me know how to make encryption and decryption with example?
What does command task mean?
how to join the two flatfiles using the joiner t/r if there is no matching port?
what is left outer join?
Can i create a lookup table without cache.
what is the diff b/w target load plan and cbl?
Write the prerequisite tasks to achieve the session partition?
How to recover sessions in concurrent batches?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Explain the difference between a data warehouse and a data mart?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?