i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
Answer Posted / siva
select nvl2(comm,-10,0) "New Comm" from employees;
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
difference of using cursor for loop and open,fetch,close.which one is better
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?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
how to write customizations in po
What are the interface tables used for ar invoices, customers, receipts for conversion process? : 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 autocashrule set? : oracle accounts receivable
How many segment are present in Oracle Manufacturing
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What Are Cross Validation & Adi?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is auto invoicing? Explain : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How to clone the database using RMAN back