Tuesday, June 5, 2012

SQL insert statement with returning clause


Declare
var1 number;
Begin
Insert into  tablename
(col1,col2 , ....) values ( value1,value2 ,....)
RETURNING
col1 into var1;
End;