hI ..how can we do 2 inserts in a cursor...?
suppose i hav two columns col1 and col 2
i want to create two records based on the values present in both colmns at the same time.
So wat should I do?

For ex table 1
col1 col2
x y

I need to insert two records
one with col1 value 'x'

and other record with col2 value y.
format will be table2
row1 x
row2 y

please put saome light on it