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
- 9963 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
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Explain how to close periods in ar. : oracle accounts receivable
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
What is an Oracle database Full Backup?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
Difference between transaction type and transaction sources. : oracle accounts receivable
What is auto invoicing? Explain : 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.
what are the tools used for oracle 10g in real time.
What is mrc and what is its use? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
