SQL & PL/SQL

Hi friends,

I have a table with six columns in it.

Initially that table will have seven rows with six columns, but all the columns wont have a content in it. But only one column will have the content of seven rows. so that's why initially it will have seven rows.

Assume that first column consist of the following seven content each in a row(so seven row)

*)A
*)B
*)C
*)D
*)E
*)F
*)G

So what i need to do is set DML operation such that for the existing seven rows which is in the table i need to update the value of the remaining six column and at the same time i need to insert all the seven rows of only the first column in the next seven rows.

Whether it is possible to do it.

How to achieve it friends,

Thanks

Regards,
Mini