what is the difference between binary_integer and
pls_integer
- 2 Answers
- 31636 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 the difference between alter trigger and drop trigger statements?
describe mysql connection using mysql binary. : Sql dba
Why is normalization important?
What operating systems are supported by oracle sql developer?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How to run sql*plus commands in sql developer?
What is a sql driver?
How does a trigger work?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Why left join is used in sql?
Which command is used to call a stored procedure?
how to select first 5 records from a table? : Sql dba
is mysql query is case sensitive? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
