i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
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 autocashrule set? : oracle accounts receivable
which one is currently in used software cmpanies.
types of receipts and detail desription about recipts and tables effected by receipts?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
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?
What are different types of transactions in ar? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is chargeback invoice? How do we create it? : oracle accounts receivable
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
which gives Oracle R12 Financial training in delhi please give me answer its urgent?