what is the difference between binary_integer and pls

what is the difference between binary_integer and
pls_integer

Question Posted / stalin

2 Answers
31098 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between binary_integer and pls_integer..

Answer / mkumar.it

Both binary_integer and pls_integer are almost same at front
end, however internal working logic are different. Both are
signed integer. For better performance, use pls_integer as
it uses machine arithmatic whereas binary_integer uses
library arithmatic. Other than this, if calculation
overflows the in pls_integer, it throws exception but
binary_integer does not.

Is This Answer Correct ?

35 Yes

7 No

what is the difference between binary_integer and pls_integer..

Answer / l. meher

The difference is :

PLS_INTEGER and BINARY_INTEGER have the same magnitude
range, they are not fully compatible. When a PLS_INTEGER
calculation overflows, an exception is raised. However,
when a BINARY_INTEGER calculation overflows, no exception
is raised if the result is assigned to a NUMBER variable.

Also, PLS_INTEGER operations use machine arithmetic, so
they are faster than NUMBER and BINARY_INTEGER operations,
which use library arithmetic.

In new applications, always use PLS_INTEGER for better
performance.

Is This Answer Correct ?

15 Yes

11 No

Post New Answer