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
- 10123 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
What is an Oracle database Full Backup?
How do you create a credit note against an invoice? : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Can you explain how to adjust the amount of advance already received 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 ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
difference of using cursor for loop and open,fetch,close.which one is better
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is Restricted Mode of Instance Startup in Oracle?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is an Oracle database Partial Backup?
How would you go about increasing the buffer cache hit ratio?
What is the sql query to find the employee who has Nth maximum salary?
