what is the difference between binary_integer and
pls_integer
- 2 Answers
- 31635 Views
- TCS, I also Faced
- E-Mail Answers
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
Is sql considered coding?
How to display Row Number with Records in Oracle SQL Plus?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is update query?
how to get @@error and @@rowcount at the same time? : Sql dba
Why do we use cursors?
What is the main difference between sql and pl/sql?
Does pl sql work in mysql?
what is primary key? : Sql dba
Why stored procedure is better than query?
What is trigger and how to use it in sql?
How do I run sql?
Does a primary key have to be a number?
define join and explain different type of joins? : Sql dba
What is the purpose of using pl/sql?
