i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
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
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Could you please let me know the interfaces in OM / FA??
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Explain the use of table functions.
What is mrc and what is its use? : oracle accounts receivable
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?
Difference between transaction type and transaction sources. : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What do you mean by hz_ in customer tables? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is an Oracle database Partial Backup?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll