Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Trunc = 20
Round= 30


Answers were Sorted based on User's Feedback

25.67,-1 Trunc = 20 Round= 30 HOW????..

Answer / chandu

select trunc(25.67,-1),round(30) from dual;

TRUNC(25.67,-1) ROUND(30)
--------------- ----------
20 30

Is This Answer Correct ?    3 Yes 3 No

25.67,-1 Trunc = 20 Round= 30 HOW????..

Answer / gaurav

The TRUNC (n1, n2) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places. n2 can be negative to truncate (make zero) n2 digits left of the decimal point.

if you do it -2. answer will be zero in this case.

similar thing goes for round.It will become zero.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

what is csv? : Sql dba

0 Answers  

use of IN/ANY/ALL

5 Answers   Ramco,

difference between anonymous blocks and sub-programs.

0 Answers  

When do we create bitmap indexes

2 Answers   CTS,

How do sql databases work?

0 Answers  

what are date and time intervals? : Sql dba

0 Answers  

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

what is HASH join?

2 Answers   Genpact, HCL,

What is nvarchar max in sql?

0 Answers  

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers