1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / rakesh anand

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

How do you bind variables in oracle?

544

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1473

Explain self joins in oracle?

561

How to list all tables in your schema?

609

What are named parameters?

615




How to export data with a field delimiter?

582

What is the recommended interval at which to run statspack snapshots, and why?

2435

Explain the types of exception?

653

How to add a new column to an existing table with a default value?

546

How can we find out the duplicate values in an oracle table?

608

What is not equal to in oracle?

526

How to pass a cursor variable to a procedure?

560

What is truncate oracle?

531

How to create an oracle database manually?

568

What is an external table?

586