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
- 10135 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How do you create a credit note against an invoice? : oracle accounts receivable
How to clone the database using RMAN back
3. Steps in UAT?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
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?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Explain about party and customer in ar : oracle accounts receivable
