Difference between Decode and Case?

Answer Posted / satishe

Decode and Case functionwill work in the same way.the only
difference is we can write conditions in side the case
function.
for Ex;
case(if c>d,d...)
decode(job,'clerk'...)

Is This Answer Correct ?    15 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1605


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

684


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9409


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

618


What are the steps to do to use alerts in bo?

625






Explain what is aggregate table and aggregate fact table ... Any examples of both?

603


How many universes can be created in a project?

591


How to create Index to the table in the universe designer and how it improves the Query performence

2111


How to restrict password to a user while sending a document in .pdf format

1850


What is a fantrap in business objects?

573


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3908


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1487


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1768


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1424


How would you format some text using css to be verdana and bold?

660