1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

Write the difference between case version and decode version.

Question Posted / shiva kumar

Answers were Sorted based on User's Feedback



Write the difference between case version and decode version...

Answer / nithya

Decode
1.It’s a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null

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

Is This Answer Correct ?    3 Yes 0 No

Write the difference between case version and decode version...

Answer / dev

Decode is widely used

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB Development Interview Questions

Explain about relational operator join?

0 Answers  

Who are naive users?

0 Answers  

What are the constraints on severity level in raiseerror?

0 Answers  

How to customize error conditions.

0 Answers  

What is database design and development?

0 Answers  




What is an extended stored procedure?

1 Answers  

Write short notes on XSU and JAVA

1 Answers  

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

What is a self join? Explain it with an example?

16 Answers   TCS,

Explain the family trees and connection by clause.

1 Answers  

In which database can extended stored procedures be added?

0 Answers  

For more DB Development Interview Questions Click Here
Categories