Hi, I'm inserting some data into table1 from table2 using the query below inside plsql.
insert into table1 (
col1
, col2
, clo3
)
select
col1
, col2
, col3
from table2;
I want to return the ID of newly inserted row from table1.
I tried,
'RETURNING ID INTO VARIBLAE'. But this is not working in 'insert into select' query.
Is there any other way?