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
- 9980 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rupali
SELECT NVL2(COMM,-10,0)AS Commission FROM emp
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is autocashrule set? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
How do you create a credit note against an invoice? : oracle accounts receivable
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
what is the link between suppliers and banks in ap module in oracle apps? And also query?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
