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.

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.

Can a composite key be null?

0 Answers  

---

How to return multiple rows from the stored procedure?

0 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

how to create temparary sequence

2 Answers   TCS,

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

---

How to add, remove, modify users using sql?

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

What are sql functions? Describe the different types of sql functions?

0 Answers  

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---