what is diff between Decode and case ? Give some Example?

Answers were Sorted based on User's Feedback



what is diff between Decode and case ? Give some Example?..

Answer / guest

In case, you can use logic as >, <, <=,>= , whereas in
decode you can only use =.

Is This Answer Correct ?    13 Yes 1 No

what is diff between Decode and case ? Give some Example?..

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

Post New Answer

More Business Objects Interview Questions

How to change font color of values in hyperlinked columns?

4 Answers  


What is the slice and dice?

3 Answers  


filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,


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??

0 Answers  


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?

0 Answers  


wat is difference b/w break and section?

4 Answers  


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.

1 Answers   Cap Gemini, TCS,


i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,


My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,


In Business Objects 4.1 version what is the alternative name for broadcast agent?

1 Answers   HP,


Categories