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
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

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

"Not Enforced" Table Constraints A constraint that is not enforced is not really a constraint within the meaning of the act, but SQL does have such a concept and it needs to b

Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons:

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t