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

What is an oracle user role?

1036

How to create a stored program unit?

1316

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1930

How do we represent comments in oracle?

1096

How do we get field detail of a table?

1125

How to end the current transaction in oracle?

1066

What is materialized view in Oracle?

1111

When system tablespace is created?

1088

Explain oracle’s system global area (sga).

1185

How to view existing locks on the database?

1098

How to create a server parameter file?

1182

How oracle handles dead locks?

1129

What is a trigger and what are its types in oracle?

1149

Difference between pre-select and pre-query

1173

How to test null values?

1154