Oracle APEX by Nandini Thakur
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;
No comments:
Post a Comment
Newer Post
Older Post
Home
View mobile version
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment