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.

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

What is offset in sql query?

0 Answers  

---

What normalization means?

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

Can we use views in stored procedure?

0 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is primary key and foreign key with example?

0 Answers  

---

Is ms sql is free?

0 Answers  

---