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
- 6 Answers
- 9895 Views
- IBM, I also Faced
- E-Mail Answers
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
Are These Dff's Flexible?
What is Restricted Mode of Instance Startup in Oracle?
Explain the use of table functions.
What is mrc and what is its use? : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
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.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
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?
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.
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
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
what are the API of GL,PO,AP
What is db_recovery_file_dest in oracle? When do you need to set this value?
