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
- 10332 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s.rajeshkumar
select nvl2(comm,0,-10) "New Comm" from employees;
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
How do you create a credit note against an invoice? : oracle accounts receivable
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 is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
How would you go about increasing the buffer cache hit ratio?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
How many segment are present in Oracle Manufacturing
What view would you use to determine free space in a tablespace?
Explain the payment term in ar. : oracle accounts receivable
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.
What is supporting issues GL AP and AR?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
