SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
Answer Posted / girija shankar dash
ANS:
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) as "result"
FROM dual;
Result
------
0
Explanation:
-----------
MOD(1600,10)---> 0
TRUNC(0,-1)----> 0
ROUND(0,2)-----> 0
| Is This Answer Correct ? | 127 Yes | 5 No |
Post New Answer View All Answers
When is a declare statement required?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is native sql query?
What are pl sql data types?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is primary key in db?
How many disk partitions should I have?
What is the use of prepared statement?
what is the different between now() and current_date()? : Sql dba
Show the cursor attributes of pl/sql.
How do you determine the current isolation level? : Transact sql
How do you delete duplicates in sql query using rowid?
Why is normalization important?
How to prepare for oracle pl sql certification?
What is the syntax to add a record to a table?