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

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

Question Posted / rakesh anand

2 Answers
31422 Views
I also Faced
E-Mail Answers

Answer Posted / rakesh anand

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

Is This Answer Correct ?

32 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the predefined tablespaces in a database?

1145

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2505

How do I start tns listener?

1099

What is a oracle database?

1111

What is procedure overloading in oracle?

1114

how can we store any pdf file in oracle

2222

What do you mean by a database transaction & what all tcl statements are available in oracle?

1037

What is SQL access advisor in Oracle?

1231

What is a named program unit?

1138

Describe an oracle table?

1100

What is an Oracle index?

1704

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2080

How to create a table in a specific tablespace?

1029

What is the sql query to concatenate column values from multiple rows in oracle?

1106

how to make an oracle object

2397