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
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
8. Supporting AP, AR and GL?
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?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Explain the use of table functions.
Difference between negative and positive adjustments : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.