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 / prajakta

select case when comm is null then 0 else -10 end from emp

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is autocashrule set? : oracle accounts receivable

1404


which one is currently in used software cmpanies.

2153


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

2075


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2192


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2327


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1349


What are different types of transactions in ar? : oracle accounts receivable

1299


What view would you use to determine free space in a tablespace?

2224


Explain the process of recievables in oracle financials. : oracle accounts receivable

1155


What is auto invoicing? : oracle accounts receivable

1159


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2401


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1047


What is chargeback invoice? How do we create it? : oracle accounts receivable

1333


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641


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

2499