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 difference between nested subquery and correlated subquery?

1061

Why partition by is used in sql?

1049

What is the difference between rename and alias?

1351

How to return an array from java to pl/sql?

1149

What will you get by the cursor attribute sql%notfound?

1090

Is sql between inclusive?

1143

what is a composite primary key ? : Sql dba

1059

What is bulk compiling in pl/sql.?

1140

What does inner join mean?

1182

what are the different index configurations a table can have? : Sql dba

1004

how to convert character strings to numeric values? : Sql dba

1117

What is parameter substitution in sql?

1036

What is procedure explain with example?

970

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

1245

How do I run a sql query?

1032