select trunc(round(156.00,-1),-1) from dual;

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...

select trunc(round(156.00,-1),-1) from dual;

Question Posted / samba

2 Answers
31291 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select trunc(round(156.00,-1),-1) from dual;..

Answer / samba

160.

Is This Answer Correct ?

53 Yes

4 No

select trunc(round(156.00,-1),-1) from dual;..

Answer / rakesh anand

TRUNC(ROUND(156.00,-1),-1)
----------------------------
160

Is This Answer Correct ?

32 Yes

2 No

Post New Answer

More Oracle General Interview Questions

What is a cursor in oracle?

How to get a list of all user accounts in the database?

What is a nested table and how is it different from a normal table?

What are named parameters?

Is oracle the best database?

can a view be updated?

Why required to run root.sh at the time of installation and what exactly it will do

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

How to write date and time interval literals in oracle?

How to invoke the data pump import utility?

can u call user defined functions in select statements

Explain oracle instance.

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)