what is the difference between binary_integer and
pls_integer
Answer Posted / 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 View All Answers
What is normalization in a database?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is the syntax and use of the coalesce function?
How do I view tables in mysql?
What is the best partition size for windows 10?
What is left join example?
what is try_catch block in procedure
What is the difference between delete, truncate and drop command?
What is user in sql?
What are the operators in sql?
Is pl sql different from sql?
What are the different sql commands?
How do you create a unique index?
What pl/sql package consists of?
Is a secondary key the same as a foreign key?