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
When to use inner join and left join?
Explain the uses of a database trigger?
What does stand for in sql?
What is pl sql record in oracle?
How insert into statements in sql?
What are the properties of a transaction?
What are different methods to trace the pl/sql code?
What is schema in sql example?
what is 'mysqlcheck'? : Sql dba
What is a pdo connection?
Can sql function call stored procedure?
How do I quit sql?
Can I learn sql in a week?
What is a data definition language?
Enlist the data types that can be used in pl/sql?