1.

What are SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data Types in PL/SQL?

Answer»

The DBMS_TRACE package has the INTERFACE to trace PL/SQL FUNCTIONS, procedures, and exceptions. The package provides subprograms to start and STOP PL/SQL TRACING in a session.

The FOLLOWING are the constants of the DBMS_TRACE package:

  • TRACE_ALL_CALLS: Traces calls or returns
  • TRACE_ALL_EXCEPTIONS: Traces exceptions
  • TRACE_ENABLED_EXCEPTIONS: Traces exceptions and handlers
  • TRACE_LIMIT: Save only the last few records.
  • TRACE_ALL_SQL: Traces SQL statements
  • TRACE_ENABLED_SQL: Traces SQL statements at PL/SQL level.
  • TRACE_ALL_LINES: Traces each line
  • TRACE_PAUSE: Pauses trancing
  • TRACE_RESUME: Resume tracing
  • TRACE_STOP: Stops tracing


Discussion

No Comment Found

Related InterviewSolutions