+1 vote
in PL/SQL by
Explain what Is The Difference Between The Code Syntax Of An Anonymous Block And Named Subprogram Block?

1 Answer

0 votes
by

A subprogram has two parts: subprogram specification and subprogram body.

The subprogram specification is the header section, which contains the details such as program name, subprogram type, parameter list, and return clause (for functions).

The subprogram body is a PL/SQL block, which has the declaration, executable, and exception sections.

An anonymous block has no specification or header section. It only consists of a PL/SQL block in the body that contains the declaration, executable, and exception sections.

Related questions

0 votes
asked Mar 18, 2021 in PL/SQL by sharadyadav1986
0 votes
asked Mar 15, 2021 in PL/SQL by Robindeniel
...