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 drop an index?

910

How many types of table in Oracle?

1063

How to convert characters to times in oracle?

955

Is there an oracle sql query that aggregates multiple rows into one row?

934

How to convert dates to characters in oracle?

988

What is the usage of analyze command in oracle?

1033

Hi Can any one tell me what are the API's used in requisition import.

1881

What do you mean by group by clause?

979

IS it possible to built the oracle database without setting the kernal parameters?

2272

Explain a segment?

1021

What is meant by joins? List out the types of joins.

960

How to list all indexes in your schema?

1034

What is execute immediate in oracle?

951

Is oracle a language?

900

What is using clause and give example?

999