Answers were Sorted based on User's Feedback
Answer / chandu
select trunc(25.67,-1),round(30) from dual;
|Is This Answer Correct ?||3 Yes||3 No|
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|
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?
what is csv? : Sql dba
use of IN/ANY/ALL
difference between anonymous blocks and sub-programs.
When do we create bitmap indexes
How do sql databases work?
what are date and time intervals? : Sql dba
Types of indexes. What is the default key created when a primary key is created in a table ?
in materialized view the structure will create immediately or not?
what is HASH join?
What is nvarchar max in sql?
I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?