Use the pls_integer datatype - performance of application, PL-SQL Programming

Use the PLS_INTEGER Datatype

When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER values need less storage than INTEGER or NUMBER values that are represented internally as 22-byte Oracle numbers. The PLS_INTEGER operations also use machine arithmetic, Therefore they are faster than BINARY_INTEGER, INTEGER, or NUMBER operations, that uses the library arithmetic. Moreover INTEGER, NATURAL, NATURALN, POSITIVE, POSITIVEN, and SIGNTYPE are constrained subtypes. Therefore, their variables need precision checking at the run time that can affect the performance.

Posted Date: 10/5/2012 5:00:26 AM | Location : United States

Related Discussions:- Use the pls_integer datatype - performance of application, Assignment Help, Ask Question on Use the pls_integer datatype - performance of application, Get Answer, Expert's Help, Use the pls_integer datatype - performance of application Discussions

Write discussion on Use the pls_integer datatype - performance of application
Your posts are moderated
Related Questions
%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

Declarations in SQL Your program stores values in the variables and constants. As the program executes, the value of the variables can change, but the values constants cannot.

%ISOPEN The Oracle closes the SQL cursor automatically after executing its related SQL statement. As a result, the %ISOPEN forever yields FALSE.

Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Exception handling In the PL/SQL, a warning or error condition is known as an exception. The Exceptions can be internally defined (by the run-time system) or user defined. The

Example of DELETE - SQL As with UPDATE, a FOR PORTION OF clause can be specified if the target table has a defined period name, as illustrated in Example. Example: Deleting

Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,

Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th