Difference between Decode and Case?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Answer / neeraj
Can anyone explain me Null value handle by Case & Decode with Example.
Is This Answer Correct ? | 0 Yes | 0 No |
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
Can Bo generates the Report from the cubical data Explain?
What Is The Difference Between Oltp And Olap?
I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps
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..
what is crystal reports?how to migrate them?
What is report template in b.o?
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?
whats the Diffrerence between business objects and cognos?
How will you test a BO report
Migration of Reports from business objects 5.1.5 to samee version in different hardware?