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
- 9909 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / prajakta
select case when comm is null then 0 else -10 end from emp
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How would you determine who has added a row to a table?
What is the difference between recovery and restoring of the oracle database?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
what is difference between inner join & nested query or subqueries
What Are Cross Validation & Adi?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is supporting issues GL AP and AR?
Explain the use of table functions.
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is auto invoicing? Explain : oracle accounts receivable
