what is diff between Decode and case ? Give some Example?
Answer Posted / jj@hotmail.com
Decode is similiar to an if statement and is Oracle
specific. The Case statement is more universal. The case
statement is more efficient in that it will exit the logic
when it evaluates true. It is also easier to read.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what will be the contents for a functional requirements specifications
what is document design in boxi,have u participate in that
What are the steps to do to use alerts in bo?
Explain about a time when you discovered a more efficient way to do a work task?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What three things do you consider to be the most important factors for a manager?
how to create reports on screech?
What is Indexing? how did u implement indexing?
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?
Explain when we use aggregate awareness function in designer?
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....
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What are all difference between business objects 6.5 and xi r2?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?