posted 13 years ago
Hi,
I am trying to copy couple of rows from same table with hibernate sequence value for column.
insert into emp(ID,name) values ( hibernate_sequence.nextval ,
(select name from emp where ref_id=10)
)
as there are multiple rows in with ref_id equal to 10 i am getting an error single row subquery returns more than one row
can anyone please let me know if there way to accomplish the above.
Thanks in advance
Smitha