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
Give two methods you could use to determine what DDL changes have been made.
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
How would you go about increasing the buffer cache hit ratio?
Explain accounting for invoice in advance and arrears. : 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 difference between inner join & nested query or subqueries
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
A scenario for amount correction & how to use amount correction functionality in AP invoices
8. Supporting AP, AR and GL?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
How to clone the database using RMAN back
types of receipts and detail desription about recipts and tables effected by receipts?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure