what is the difference between binary_integer and
pls_integer
- 2 Answers
- 31128 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 view means?
how to add a new column to an existing table in mysql? : Sql dba
What is difference between sql function and stored procedure?
Can we create table in function?
what is a composite key ? : Sql dba
What are two statement types in sql?
Explain constraints in sql?
What is not equal in sql?
What has stored procedures in sql?
How to change the order of columns in Oracle SQL Plus ?
how to enter binary numbers in sql statements? : Sql dba
Is full outer join same as cross join?
Which table is left in left join?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Why do we need cursors in pl sql?
