TRUNC(ROUND(156.00,-1),-1) ---------------------------- 160

select trunc(round(156.00,-1),-1) from dual;

Question Posted / rakesh anand

Answer Posted / rakesh anand

TRUNC(ROUND(156.00,-1),-1)
----------------------------
160

Is This Answer Correct ?

32 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why is oracle database so popular?

1020

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5423

Define oracle database

1050

Explain an extent?

1114

Explain a segment?

1095

How to get last row id?

1009

What are the parameters that we can pass through a stored procedure?

1073

How to set a transaction to be read only in oracle?

1100

Please explain oracle left join with an example?

1055

what are bitmap indexes? How does they work?

2266

How do I know if oracle client is installed on windows?

1035

What is columnar storage what is the advantage?

1071

How to start instance with a minimal initialization parameter file?

1050

What is the difference between post-database commit and post-form commit?

1210

How to convert character types to numeric types?

1142