ANS: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) as "result" FROM d

SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;

Question Posted / girija shankar dash

10 Answers
74063 Views
I also Faced
E-Mail Answers

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 ?

116 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you load data into multiple tables at once? : aql loader

600

how to see the create table statement of an existing table? : Sql dba

521

What will you get by the cursor attribute sql%notfound?

588

How to get list of all tables from a database?

623

Inline the values in PL/SQL, what does it mean.?

625

Sql technical questions

775

What is java sql drivermanager?

543

What is pl sql record in oracle?

563

what is a tablespace? : Sql dba

560

How do you update a value in sql?

545

What are the benefits of triggers?

593

Can we call a function containing dml statements in a select query?

537

What does select top 1 do in sql?

536

what is foreign key? : Sql dba

582

Is sql injection illegal?

595