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 is the limitation on the block size of pl/sql?

0 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

what is msql? : Sql dba

0 Answers  

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

how to delete an existing column in a table? : Sql dba

0 Answers  

---

what is heap table? : Sql dba

0 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

What is an inner join sql?

0 Answers  

---

What are the types of operators available in sql?

0 Answers  

---

How do you drop a trigger?

0 Answers  

---

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

---