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.

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

What are different types of triggers?

0 Answers  

---

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

---

What is group by in sql?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

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

0 Answers  

---

What is a primary key example?

0 Answers  

---

What are the different set operators available in sql?

0 Answers  

---

What are secondary keys?

0 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

differentiate between float and double. : Sql dba

0 Answers  

---