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

25.67,-1
Trunc = 20
Round= 30

HOW????

Question Posted / chandu

Answer Posted / chandu

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

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the most restrictive isolation level? : Transact sql

540

How many rows can sqlite handle?

568

What is the difference between jpql and sql?

540

how to create a test table in your mysql server? : Sql dba

481

Why do you partition data?

520

Explain what is rdbms?

571

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

522

What problem one might face while writing log information to a data-base table in pl/sql?

547

What is the advantage of nosql?

511

What is primary and foreign key?

581

What is memory optimized table?

565

what is 'mysqlimport'? : Sql dba

563

How to run sql statements with oracle sql developer?

606

What are the two types of exceptions.

619

is it possible to pass an object or table to a procedure as an argument?

553