i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
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
What is an Oracle database Partial Backup?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
HOW TO SPOT AHIERARCHY?
What is the importance of batch source set up in ar? : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
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
What is Restricted Mode of Instance Startup in Oracle?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
i want to know about the javaBean.what is its purpose and how it can use in Forms.
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Difference between negative and positive adjustments : oracle accounts receivable
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.