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.

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

---

How to process query result in pl/sql?

0 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

What are % type and % rowtype?

0 Answers  

---

What is rtm in testing?

0 Answers  

---

What is int identity in sql?

0 Answers  

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

what is meant by databases

4 Answers  

---

What is difference between my sql and sql?

0 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---