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
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
What do you mean by hz_ in customer tables? : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is Tax Categories?
as a technical developer in oracle applications which type errors feced in your experience sofar
Where in the Oracle directory tree structure are audit traces placed?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the importance of batch source set up in ar? : oracle accounts receivable
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?
What is Restricted Mode of Instance Startup in Oracle?
How would you go about increasing the buffer cache hit ratio?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable