Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the difference between binary_integer and
pls_integer

Answers were Sorted based on User's Feedback



what is the difference between binary_integer and pls_integer..

Answer / 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

what is the difference between binary_integer and pls_integer..

Answer / l. meher

The difference is :

PLS_INTEGER and BINARY_INTEGER have the same magnitude
range, they are not fully compatible. When a PLS_INTEGER
calculation overflows, an exception is raised. However,
when a BINARY_INTEGER calculation overflows, no exception
is raised if the result is assigned to a NUMBER variable.

Also, PLS_INTEGER operations use machine arithmetic, so
they are faster than NUMBER and BINARY_INTEGER operations,
which use library arithmetic.

In new applications, always use PLS_INTEGER for better
performance.

Is This Answer Correct ?    15 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  


Why are cursors used?

0 Answers  


what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,


We have a CURSOR then we need BULK COLLECT?

1 Answers  






Is join same as left join?

0 Answers  


how to create table with in the procedure or function?

2 Answers   Genpact, HCL,


What are the types of variables use in pl sql?

0 Answers  


What are functions in sql?

0 Answers  


how to connect oracle in unix prompt?

4 Answers   Polaris,


How do you declare a user-defined exception?

0 Answers  


What is the difference between a subquery and a join?

0 Answers  


Categories