select trunc(round(156.00,-1),-1) from dual;
Answers were Sorted based on User's Feedback
Answer / rakesh anand
TRUNC(ROUND(156.00,-1),-1)
----------------------------
160
| Is This Answer Correct ? | 32 Yes | 2 No |
How do I limit the number of rows returned by an oracle query after ordering?
How to check the oracle tns settings?
What do you mean by cdb and pdb in oracle 12c?
What is an oracle user account?
What is a Public Synonyms ?
Does oracle charge for java?
Explain a private synonyms?
State the various uses of dbcc command?
Explain the difference between replace() and translate() functions in oracle?
How to display employee records who gets more salary than the average salary in the department?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
List the various oracle database objects?