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.

Why do we use subquery?

0 Answers  

---

What are wait events. Describe the wait event tables.

1 Answers   CTS,

---

What are properties of the transaction?

0 Answers  

---

What is the difference between an inner join and an outer join?

0 Answers  

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

What is the difference between distinct and unique in sql?

0 Answers  

---

What is data modelling in sql?

0 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

why we use nocopy?

2 Answers   Polaris,

---

What is rank dense_rank and partition in sql?

0 Answers  

---