Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between binary_integer and
pls_integer
- 2 Answers
- 32341 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 functions are there in sql?
Can we create table in function?
What is cascade in sql?
What is sql dialect?
How to assign sql query results to pl sql variables?
What is column?
What is the difference between Union and Union all. Which is faster.
What is set serveroutput on in pl sql?
What does trigger mean in slang?
Is natural join and inner join same?
What is meant by truncate in sql?
How do I restart sql?
what is oltp (online transaction processing)? : Sql dba
Is ms sql is free?
What is sql clause?
