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

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

Answer Posted / siva

select nvl2(comm,-10,0) "New Comm" from employees;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1082


difference of using cursor for loop and open,fetch,close.which one is better

1754


What do you mean by hz_ in customer tables? : oracle accounts receivable

1172


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2486


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

2256


What is Tax Categories?

2066


as a technical developer in oracle applications which type errors feced in your experience sofar

2291


Where in the Oracle directory tree structure are audit traces placed?

2593


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2072


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1972


What is the importance of batch source set up in ar? : oracle accounts receivable

1218


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?

2140


What is Restricted Mode of Instance Startup in Oracle?

1162


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

2560


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

1041