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 |
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers
what is difference between Rich client web intelligence and Boxir2 web intelligence
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
WHAT ARE THE VARIOUS PRODUCTS IN BO?
What is the link option in the reporting Environment?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What are @FUNCTION?
How will you move reports from Dev to QA in BO
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,