Insert Select to same table in oracle

[sudhendra]

I have a table supertask; which has 24 rows. The table as a primary_key called id.
I would like just recursively copy rows into same table.
supertask_id is auto generated.

So All I need to do is something like

insert all
into supertask (name,desc,rstrnum)
select name, desc, rstrnum from supertask;

When I execute this command, this just does select query and returns me the columns in select. Nothing gets inserted.
Can any one throw some light on this regard ?

I have gone through the sql statements in this forum, nothing seems to work.

Thanks
Sudhi

[saravanankm]

hi Sudhi

Try this qry

insert into our_table (column1,column2...column n)
select (column1,column2...column n) from our_table ;


By
Captain