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

what is the difference between binary_integer and

Answers were Sorted based on User's Feedback

what is the difference between binary_integer and pls_integer..

Answer /

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

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