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 clause in sql?

0 Answers  

---

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

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

What is cost in sql execution plan?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

display null value rows with out using null function?

8 Answers   Infosys,

---

How to load data with sql*loader?

0 Answers  

---

what are the advantages a stored procedure? : Sql dba

0 Answers  

---

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---