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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results