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

How to define an explicit cursor in oracle?

1040

What is literal?

1007

What is enter substitution variable in oracle?

1052

What are named parameters?

1093

How do I spool in oracle?

1005

What is the exact use of Collections?

2143

Explain constraining triggers.

1097

What is oracle rowcount?

1085

What happens if the imported table already exists?

1033

How to use "while" statements in oracle?

1327

How to export data to a csv file?

1306

How to convert characters to times in oracle?

1023

How to get a list of all background sessions in the database?

993

What is a dynamic performance view in oracle?

992

State some uses of redo log files?

1010