| Need answer for below block [message #643948] |
Fri, 23 October 2015 02:05  |
 |
rajesh_oracle
Messages: 2
Registered: October 2015
|
Junior Member |
|
|
DECLARE
TYPE name_rec
IS
RECORD
(
first_name VARCHAR2(20),
last_name VARCHAR2(25));
TYPE names IS VARRAY(250) OF name_rec;
v_names names :=names();
BEGIN
v_names:= names();
FOR i IN 1..5
LOOP
v_names.extend;
v_names(i).First_name :='FIRST_NAME'||I;
v_names(i).last_name :='LAST_NAME'||I;
DBMS_OUTPUT.PUT_LINE(v_names(i).first_name || '---' || v_names(i).last_name);
END LOOP;
END;
Current Output is
-------------------
anonymous block completed
FIRST_NAME1---LAST_NAME1
FIRST_NAME2---LAST_NAME2
FIRST_NAME3---LAST_NAME3
FIRST_NAME4---LAST_NAME4
FIRST_NAME5---LAST_NAME5
NEED OUTPUT AS
---------------------
anonymous block completed
FIRST_NAME A---LAST_NAME F
FIRST_NAME B---LAST_NAME G
FIRST_NAME C ---LAST_NAME H
FIRST_NAME E---LAST_NAME I
FIRST_NAME F---LAST_NAME J
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
