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
80766 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 ?

127 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why use truncate instead of delete?

1020

Is sql a oracle?

984

What are the datatypes available in pl/sql ?

1110

How do you explain an index number?

1114

Which command is used to call a stored procedure?

1006

define data blocks ? : Sql dba

1002

Can a primary key be a foreign key?

1029

What is an inner join sql?

1037

Why is sharding used?

1006

What is sqlerrd?

971

How to connect a sql*plus session to an oracle server?

1134

what is a relationship and what are they? : Sql dba

1105

What is row_number () in sql?

988

Does a join table need a primary key?

959

Can we edit a view in sql?

989