Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between binary_integer and
pls_integer
- 2 Answers
- 32198 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
List different type of expressions with the example.
how do you login to mysql using unix shell? : Sql dba
What is PL/SQL Records?
Is nosql relational?
How do I make sql search faster?
What is parallel hint?
Name some usages of database trigger?
How to display Row Number with Records in Oracle SQL Plus?
what are the differences between binary and varbinary? : Sql dba
How many triggers can be applied to a table?
Explain the uses of a database trigger?
What are the disadvantages of not performing database normalization?
What is not in sql?
What is information schema in sql?
What are the properties of a transaction?
