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
- 9948 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / swati
update emp set comm =
case
when comm is null then 0
else
10
end
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
what is difference between inner join & nested query or subqueries
What is the use of lockboxes? Steps for lock box : 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
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
how to replace not in with not exist?
3. Steps in UAT?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
what are basic modules required to implement oracle application in any oraganisation?
