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
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are the steps to do to use alerts in bo?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
How many universes can be created in a project?
How to create Index to the table in the universe designer and how it improves the Query performence
How to restrict password to a user while sending a document in .pdf format
What is a fantrap in business objects?
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??
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....
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?
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
How would you format some text using css to be verdana and bold?