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 there be 2 primary keys in a table?

0 Answers  

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

Give the order of sql select?

0 Answers  

---

What is denormalization in a database?

0 Answers  

---

---

What is the difference between a primary key and a unique key?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---

What is sql exception?

0 Answers  

---

Types of backups ?

3 Answers   TCS,

---

What are the advantages of the packages

6 Answers   Oracle,

---

How do I remove sql developer from windows 10?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---