hi everyone
how i can do that
i have string x = '1,2,3,4'
and string y='user name'
how i can split this x
as
insert into tablename (id,username)
values ('user name',1)
insert into tablename (id,username)
values ('user name',2)
insert into tablename (id,username)
values ('user name',3)
insert into tablename (id,username)
values ('user name',4)