what is the difference between binary_integer and
pls_integer
Answers were Sorted based on User's Feedback
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 |
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 |
How can we make an if statement within a select statement?
What is a left join?
What is using in sql?
How is use pl and sql?
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
What is cte sql?
What is the purpose of primary key?
what are myisam tables? : Sql dba
Does normalization improve performance?
When can we use the where clause and the having clause?
What is pl sql record in oracle?
what is the difference between trigger and constraint?