Difference between Decode and Case?

Answers were Sorted based on User's Feedback



Difference between Decode and Case?..

Answer / pari

Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null

Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null

Is This Answer Correct ?    52 Yes 11 No

Difference between Decode and Case?..

Answer / judith

Decode
The default operator for comparison is '=',
for e.g select deptno,decode
(deptno,10,'dept10',20,dept20,default)

so if the deptno=10 then the value is replaced by dept10
and so on,

whereas in Case:

we can use any operator other than '=',
for e.g
select deptno,
case when deptno=10 and sal>1000 then 'dept10'
else
'dept20'

Hope the difference is made clear.

Regards,
Judith

Is This Answer Correct ?    33 Yes 8 No

Difference between Decode and Case?..

Answer / vasu

Decode: using for reporting purpose. and it is implemented
by if stmt.
Ex: select decode(job,'CLERK','executive',job) from emp;

Case : implemented by if & elsif condition. it is using
pl/sql equality conditionality.
Ex : select case job='CLERK' then 'executive' else 'no' end
a from emp;

it is also used for multipul colms & multi conditions.

in above stmt a is reffered alias name.

Is This Answer Correct ?    24 Yes 16 No

Difference between Decode and Case?..

Answer / suman vyas

1) Case Can work with logical operator other than '=' . such as < , > , = < , >=
where Decode performs an equality check only.

2) Decode can work as function inside SQL only,
where Case can work in Pl/Sql as a substitute of IF-THEN-ELSE.

3) Decode can not process Null , where Case can process Null.

4) Case expects datatype Consistency, Decode Dose not.

5) Decode is a function, where Case is a statement.

hope this will give u satisfied Answer for Difference Between CASE AND DECODE.

Thanks
Suman Vyas

Is This Answer Correct ?    7 Yes 0 No

Difference between Decode and Case?..

Answer / 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

Difference between Decode and Case?..

Answer / gurujothi

*CASE can only be used inside the SQL statement where as CASE can be used anywhere even as a parameter of a function or procedure.
*Decode can do equality check only but Case can do more logic comparisons such as <,>etc.,
*The Case will handle NULL differently

Is This Answer Correct ?    4 Yes 3 No

Difference between Decode and Case?..

Answer / zeya.ocp

CASE Expr make u use IF-THEN-ELSE logic in sql statements without to invoke procedure.It complies with ANSI SQL.
DECODE function decode an expr in a way similar to IF-THEN-ELSE logic that is used in various languages.it facilitate conditional inquiries.

Is This Answer Correct ?    2 Yes 1 No

Difference between Decode and Case?..

Answer / neeraj

Can anyone explain me Null value handle by Case & Decode with Example.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,


What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,


Can Bo generates the Report from the cubical data Explain?

0 Answers   Wipro,


What Is The Difference Between Oltp And Olap?

0 Answers   Informatica,


I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps

17 Answers   IBM,






HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,


what is crystal reports?how to migrate them?

2 Answers   IBM,


What is report template in b.o?

0 Answers  


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,


whats the Diffrerence between business objects and cognos?

1 Answers  


How will you test a BO report

3 Answers   Infosys,


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

0 Answers   Arkema pte Ltd,


Categories