Sir I have this data

CREATE CURSOR table1(code c(4),names c(10),debit n(4),credit n(4),code2 c(4))
INSERT into table1 VALUES ('3201','Apple',100,0,'')
INSERT into table1 VALUES ('3203','Mango',125,0,'')
INSERT into table1 VALUES ('3204','Date',200,0,'')
INSERT into table1 VALUES ('3202','Orange',350,0,'')

I want insert following rows at the end of table1




Method:

code column will be replace with code2
Debit column will be replaced with credit
Credit column will be replaced with debit
code2 column will be replace with code

But I do not want to use any temporary table or cursor.

Is there any other method to make data double according to method.

Finally I need this data



Please