1.

What is a Subtype in PL/SQL?

Answer»

The following are some of the Oracle Database PL/SQL packages:

  • DBMS_ALERT

You can use the database triggers to alert an APPLICATION when a database values change.

  • DBMS_OUTPUT

You may have USED PUL_LINE in this package to display output from PL/SQL blocks, subprograms, packages, and triggers. This also displays debugging information.

  • DBMS_PIPE Package

This package lets different sessions to communicate over NAMED pipes

  • HTF and HTP Packages

This allows the PL/SQL programs to generate HTML tags.

  • UTL_SMTP

Using this package, you can send emails over SMTP (Simple Mail Transfer Protocol).


Discussion

No Comment Found

Related InterviewSolutions