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
What is primary key in db?
How to select unique records from a table?
What is audit logout in sql profiler?
What is the use of <> sql?
what are local and global variables and their differences? : Sql dba
What are the main features of cursor?
What does select * from mean in sql?
How do sql triggers work?
What is rownum in sql?
How can we store rows in PL/SQL using array?
What is cte sql?
What is nvarchar in sql?
How does cross join work in sql?
Write the command to remove all players named sachin from the players table.
Cite the differences between execution of triggers and stored procedures?