i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value

Answer Posted / shaik

select e.*,decode(comm,null,0,-10) new_comm
from emp e

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give two methods you could use to determine what DDL changes have been made.

6353


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2096


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2025


How would you go about increasing the buffer cache hit ratio?

2222


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

800


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1869


what is difference between inner join & nested query or subqueries

2698


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3574


A scenario for amount correction & how to use amount correction functionality in AP invoices

1860


8. Supporting AP, AR and GL?

2032


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1871


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2125


How to clone the database using RMAN back

1812


types of receipts and detail desription about recipts and tables effected by receipts?

1825


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1736