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
- 9911 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shaik
select e.*,decode(comm,null,0,-10) new_comm
from emp e
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How would you determine who has added a row to a table?
Explain prerequisites and post activities of oracle database installation
How do you create a credit note against an invoice? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
which one is currently in used software cmpanies.
What is the importance of batch source set up in ar? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
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?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Can we modify approve purchase order?if yes what is navigation?
What is the use of lockboxes? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
How would you go about increasing the buffer cache hit ratio?
