Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Comma Separate Logic

444621Jan 11 2006 — edited Mar 9 2006
Hi to All,

I have two variables like this
DECLARE

v_char_type VARCHAR2(500);
v_num_type VARCHAR2(250);

BEGIN

v_char_type := 'A,B,C,D,E,F,G,H';
v_num_type := '1,2,3,4,5,6,7,8';

How do I print the values like

A 1
B 2
C 3
D 4
E 5
F 6
G 7
H 8

Thanks for Help.

END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2006
Added on Jan 11 2006
13 comments
4,292 views