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 |
Explain normalization and what are the advantages of it?
How many databases can sql express handle?
What is the use of function "module procedure" in pl/sql?
What is primary key and foreign key?
What is asqueryable?
What are Lexical Parameters.How They are used in Reports 6i
What is a database link?
When sql appeared?
Can we use insert statement in function?
What are tables and fields?
What is int identity in sql?
What is left join in postgresql?