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

How are sql commands classified?

1038

How is debugging done?

921

What is partition in sql query?

950

What port does sql server use?

989

What is database migration?

916

What is materialized view in sql?

875

Explain alias in sql?

997

What are the types of dbms?

922

What are the different types of triggers?

1057

Why functions are used in sql?

932

how to convert character strings to dates? : Sql dba

985

How many types of primary keys are there?

980

What is replication id?

886

What are all ddl commands?

1016

Can dml statements be used in pl/sql?

1021