i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 9010 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
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What view would you use to determine free space in a tablespace?
How to clone the database using RMAN back
What Are Cross Validation & Adi?
What is Restricted Mode of Instance Startup in Oracle?
which one is currently in used software cmpanies.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
What is auto invoicing? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
difference of using cursor for loop and open,fetch,close.which one is better
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
