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.

How does sql store data?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

Which is faster count (*) or count 1?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

What does trigger mean in psychology?

0 Answers  

---

Is ms sql traffic encrypted?

0 Answers  

---

What is a delimiter in sas?

0 Answers  

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

What is tuple in sql?

0 Answers  

---

How do you clear the screen in sql?

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---