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 are different types of transactions in ar? : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?
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.
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what is difference between inner join & nested query or subqueries
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is the importance of batch source set up in ar? : oracle accounts receivable
How to clone the database using RMAN back
i want to know about the javaBean.what is its purpose and how it can use in Forms.
difference of using cursor for loop and open,fetch,close.which one is better
What is supporting issues GL AP and AR?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5