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 does one get the view definition of fixed views/tables?
What are the ways tablespaces can be managed and how do they differ?
How can Oracle users be audited?
What is the difference between formal parameters and actual parameters?
Difference between varchar and varchar2 data types?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
How to create a new view in oracle?
What is the difference between truncate & delete command?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How do I spool in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?