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

Question Posted / samba

2 Answers
31421 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / samba

160.

Is This Answer Correct ?

53 Yes

4 No

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

Answer / rakesh anand

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

Is This Answer Correct ?

32 Yes

2 No

Post New Answer

More Oracle General Interview Questions

create one table to capture an employee details with a primary key.

1 Answers CTS,

How to find no of saturdays in a month using single sql ?

2 Answers

how to find count rows in table without count function?

3 Answers Oracle,

In the oracle version 9.3.0.5.0, what does each number shows?

0 Answers

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

0 Answers Wipro,

What is Undo Management Advisor in Oracle?

0 Answers MCN Solutions,

How to start your 10g xe server?

0 Answers

State and explain about oracle instance?

0 Answers

What is SAVE POINT ?

5 Answers

How to load excel data sheet to oracle database

0 Answers

What is meant by joins?

0 Answers

When can Hash Cluster used ?

1 Answers

For more Oracle General Interview Questions Click Here