Answers

Question and Answer:

  Home  DB Development

⟩ What is the difference between case version and decode version?

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

 215 views

More Questions for you: