Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between binary_integer and
pls_integer
- 2 Answers
- 32504 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 to display the records between two range in Oracle SQL Plus?
Which one is faster ienumerable or iqueryable?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What are the different types of functions in sql?
How can we implement rollback or commit statement in a trigger?
What is sql mysql pl sql oracle?
discuss about myisam key cache. : Sql dba
Why do you partition data?
What can you do with pl sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are tables and fields in the database?
What is rowtype?
What is structural independence and why is it important?
What is sql not null constraint?
Can we rollback after truncate?
