Answer / chandu

select trunc(25.67,-1),round(30) from dual;

TRUNC(25.67,-1) ROUND(30)
--------------- ----------
20 30

Answer / gaurav

The TRUNC (n1, n2) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places. n2 can be negative to truncate (make zero) n2 digits left of the decimal point.

if you do it -2. answer will be zero in this case.

similar thing goes for round.It will become zero.

Why use truncate instead of delete?

0 Answers  

---

What is having clause in sql?

0 Answers  

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

Which is the correct statement about truncate and delete?

0 Answers  

---

Explain the methods used to protect source code of pl/sql.

0 Answers  

---

Explain alias in sql?

0 Answers  

---

there are .......different types of serializability

1 Answers   Wipro,

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

What is sql character function?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

what is a trigger? : Sql dba

0 Answers  

---

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

---