You can create a subprogram either inside a PL/SQL block (which can be another subprogram), inside a package, or at schema level. A subprogram created inside a PL/SQL block is a nested subprogram.

Where can a sub program be created?

At the schema level, subprogram is a standalone subprogram. It is created with the CREATE PROCEDURE or the CREATE FUNCTION statement. It is stored in the database and can be deleted with the DROP PROCEDURE or DROP FUNCTION statement. A subprogram created inside a package is a packaged subprogram.

In which of the following can a subprogram not be created?

Declaration of a subprogram can be written after the execution but not possible in anblock.