what is the difference between binary_integer and
pls_integer
- 2 Answers
- 31085 Views
- TCS, I also Faced
- E-Mail Answers
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 package in pl sql with an examples?
Why are indexes and views important to an organization?
How insert into statements in sql?
What is a unique key?
What is a memo field?
What is full join in sql?
how to install mysql? : Sql dba
What is sql used for?
how is myisam table stored? : Sql dba
What is multiple partition?
what is column? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
What has stored procedures in sql and how we can use it?
give the syntax of grant and revoke commands? : Sql dba
What is trigger in sql?
