SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
Answer Posted / manish kumar
0.00
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is Histogram?
Can ddl statements be used in pl/sql?
What is sqlerrm?
What are the various restrictions imposed on view in terms of dml?
How is pl sql different from sql?
What are the benefits of pl sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
how to return query output in html format? : Sql dba
What is a temporal table?
What are the different types of dbms?
How do I remove sql plus from windows 10?
What are the topics in pl sql?
How would you convert date into julian date format?
What are the advantages of pl sql over sql?
what is the difference between a having clause and a where clause? : Sql dba