what is the difference between binary_integer and
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
|Is This Answer Correct ?||15 Yes||11 No|
can i use dbms_output.put_line in a function u are telling as return statement
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Why are cursors used?
what is the difernece between named and anonymous pl/sql blocks??
We have a CURSOR then we need BULK COLLECT?
Is join same as left join?
how to create table with in the procedure or function?
What are the types of variables use in pl sql?
What are functions in sql?
how to connect oracle in unix prompt?
How do you declare a user-defined exception?
What is the difference between a subquery and a join?