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.

Can %notfound return null after a fetch?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

what is called after appearing where clause

3 Answers  

---

How do you remove duplicate records from a table?

0 Answers  

---

---

can i give user defined exception in a package

2 Answers  

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

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

2 Answers  

---

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

---

Is not equal in sql?

0 Answers  

---

What are records give examples?

0 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---