what is the difference between binary_integer and
pls_integer
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
What are sql functions? Describe in brief different types of sql functions?
What is the difference between partition and index?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Is clustered index a primary key?
Why do we use procedures?
What do we need to check in database testing?
What is cursor status?
explain advantages of innodb over myisam. : Sql dba
Is left join same as inner join?
What is a sql statement?
What is the difference between left and left outer join?
Does user triggers have entry for trigger with compilation errors?
What is a schema sql?
Which sorts rows in sql?
what is isam? : Sql dba