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
Blocks: The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the b

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that th

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Create a Oracle procedure to produce vertical output format when selecting rows from a database table.

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server