what is diff between Decode and case ? Give some Example?
Answers were Sorted based on User's Feedback
Answer / guest
In case, you can use logic as >, <, <=,>= , whereas in
decode you can only use =.
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / 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 |
How to change font color of values in hyperlinked columns?
What is the slice and dice?
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
wat is difference b/w break and section?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
i want to take a report 10 records per page. How to take it? is there any paging option in BO?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
In Business Objects 4.1 version what is the alternative name for broadcast agent?