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
- 10334 Views
- IBM, I also Faced
- E-Mail Answers
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 view would you use to determine free space in a tablespace?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What are different types of transactions in ar? : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
What is chargeback invoice? How do we create it? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
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?
