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

Question Posted / samba

2 Answers
31215 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

How to experiment a data lock in oracle?

0 Answers

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers HCL, IBM,

What is difference between truncate and delete?

0 Answers

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 Answers

How to create id with auto_increment on oracle?

0 Answers

What are the type of Synonyms?

1 Answers

what is the difference between simple view and complex view?

13 Answers

which statement is running fastly ie insert or delete?

13 Answers Oracle,

what is trigger?

6 Answers Oracle,

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers

What happens to the current transaction if the session is ended?

0 Answers

How to convert character types to numeric types?

0 Answers

For more Oracle General Interview Questions Click Here