what is the difference between binary_integer and
pls_integer
Answer Posted / mkumar.it
Both binary_integer and pls_integer are almost same at front
end, however internal working logic are different. Both are
signed integer. For better performance, use pls_integer as
it uses machine arithmatic whereas binary_integer uses
library arithmatic. Other than this, if calculation
overflows the in pls_integer, it throws exception but
binary_integer does not.
| Is This Answer Correct ? | 35 Yes | 7 No |
Post New Answer View All Answers
How do you explain an index number?
what are the nonstandard string types? : Sql dba
What is the difference between alter trigger and drop trigger statements?
what tools available for managing mysql server? : Sql dba
What is a database? Explain
What is an invalid partition table?
what is collation? : Sql dba
What are the parameter modes supported by pl/sql?
What are the differences between implicit and explicit cursors?
what is a foreign key ? : Sql dba
What does the acronym acid stand for in database management?
what are the properties and different types of sub-queries? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
How do I delete a trigger?
How do I truncate a sql log file?