The Oracle Database Documentation and other resources use these sample schemas to demonstrate the capabilities of Oracle Database and the SQL and PL/SQL languages ...
To return a value from a DML command (for example, a newly generated ID from an INSERT), you can use a PL/SQL block with the RETURNING INTO clause. This requires configuring an output bind variable.
Learning Oracle PL/SQL by Pribyl, Bill Publication date 2002 Topics Oracle (Computer file), PL/SQL (Computer program language) Publisher Sebastopol, CA : O'Reilly Collection internetarchivebooks; ...