Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between binary_integer and
pls_integer
- 2 Answers
- 32368 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
How many types of cursors are available in pl/sql?
How do I run a sql trace?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is example of database?
How do you use a while loop in pl sql?
What are some emotional triggers?
What is normalization? How many normalization forms are there?
What are actual parameters and formal parameters?
what is commit? : Sql dba
What are the operators used in select statements?
Can we insert in view in sql?
What is pivot table in sql?
Is sql microsoft?
What is the use of index in sql?
What are the set operators in sql?
