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

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

Question Posted / rakesh anand

2 Answers
29368 Views
I also Faced
E-Mail Answers

Answer Posted / rakesh anand

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

Is This Answer Correct ?

32 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is meant by magic query

1764

How many categories of data types?

570

How to define a procedure inside another procedure?

537

how the indexes are stored in the Oracle Database?

1732

What are the differences between char and nchar in oracle?

589

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2879

What is an oracle user account?

568

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1640

Point the difference between translate and replace?

564

How to retrieve the count of updated rows?

568

Please explain oracle data types with examples?

580

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1697

What is the difference between translate and replace?

546

Can we save images in a database and if yes, how?

584

How to assign values to variables?

574