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

Question Posted / samba

2 Answers
31086 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

Explain the use of log option in exp command.

0 Answers

What are nested tables?

0 Answers

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers TCS,

what is Table ?

2 Answers

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers

How to convert numbers to characters in oracle?

0 Answers

How to divide query output into groups in oracle?

0 Answers

How to create a table index in oracle?

0 Answers

What is the difference between online and offline backups?

0 Answers MCN Solutions,

What is the difference between a user and a schema in oracle?

0 Answers

can a view be updated?

3 Answers

For more Oracle General Interview Questions Click Here