Pragma applications - PL/SQL Elements

Q.  For which of the following can pragma be applied?
- Published on 08 Jul 15

a. Top-level (not nested) anonymous PL/SQL blocks
b. Local, standalone, and packaged functions and procedures
c. Methods of a SQL object type
d. Database triggers
e. All mentioned above

ANSWER: All mentioned above
 
The pragma is marked to a subprogram so that it can do the SQL operations and commit or rollback these operations. That is why a pragma can be applied to all the options mentioned above.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲