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.

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

real time applications of nullif?

3 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

Can delete statement be rollbacked?

0 Answers  

---

Can we insert data in view?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

What are pl/sql cursor exceptions?

0 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

How does pl sql work?

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

How to select 10 records from a table?

0 Answers  

---