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 to omit columns with default values in insert statement in oracle?
Explain oracle insert into command?
How to use "out" parameter properly?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
what is the difference between authorization and authentication?
What do you understand by a database object?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
how to find count rows in table without count function?
Can we save images in a database and if yes, how?
What is control file used for?
What is a public synonym?
How many memory layers are in the shared pool?