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

update emp set comm =
case
when comm is null then 0
else
10
end

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2920


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2110


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.

2260


where the dff data will be stored

2537


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2569


Explain the use of table functions.

2583


what are basic modules required to implement oracle application in any oraganisation?

2259


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1478


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

2336


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.

3995


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

17785


What are different types of receipt reversals ? Explain them : oracle accounts receivable

1319


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

2556


what are the tools used for oracle 10g in real time.

2491


what is semphore explian it?

2880