1.

How to execute a standalone procedure in PL/SQL?

Answer»

The SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data TYPES introduced in PL/SQL 11g Release 1. These are predefined subtypes of PLS_INTEGER, BINARY_FLOAT, and BINARY_DOUBLE, respectively.

The SIMPLE_FLOAT and SIMPLE_DOUBLE DATATYPES are alike their base types, except for their NOT NULL constraint.

  • SIMPLE_INTEGER:  When the value will never be NULL and overflow checking is unnecessary.
  • SIMPLE_FLOAT: When the value will never be NULL.
  • SIMPLE_DOUBLE: When the value will never be NULL.

The SIMPLE_FLOAT and SIMPLE_DOUBLE has BETTER performance than BINARY_FLOAT and BINARY_DOUBLE.

SIMPLE_INTEGER is a predefined subtype of the PLS_INTEGER data type and differs from it in its overflow semantics. It has the same range as PLS_INTEGER i.e. -2,147,483,648 through 2,147,483,647) and has a NOT NULL constraint.


Discussion

No Comment Found

Related InterviewSolutions