Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

25.67,-1
Trunc = 20
Round= 30

HOW????

Question Posted / rashmi

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

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

can i write pl/sql code in a package

2 Answers  

List the different type of joins?

0 Answers  

What is the use of sqlerrd 3?

0 Answers  

Is progress software supports to ( pl/sql )?

0 Answers  

What is substitution variable in pl sql?

0 Answers  

How many types of sql are there?

0 Answers  

What is data profiling in sql?

0 Answers  

What port does sql server use?

0 Answers  

What is compute?

0 Answers  

Is sql sequential or random?

0 Answers  

how to get help information from the server? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories