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

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

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.

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

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'...)

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

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.

Answer / neeraj

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

Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

Without using OBJECTS Can i write AND run a query in webi/desi? HOW?

3 Answers   Mind Tree,

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

9.what are the multidimensional analyses

4 Answers   TCS,

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

4 Answers   Fujitsu, Virtusa,

Tell me about a complicated object you have created?

1 Answers  

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  

WHAT KIND OF TOOL BO IS?

7 Answers