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
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?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
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.
where the dff data will be stored
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
Explain the use of table functions.
what are basic modules required to implement oracle application in any oraganisation?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
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.
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
What are different types of receipt reversals ? Explain them : oracle accounts receivable
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
what are the tools used for oracle 10g in real time.
what is semphore explian it?