What is the difference between case version and decode version?
Submitted by: AdministratorDecode
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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online DB Development Job Interview Questions And Answers
Top DB Development Questions
| ☺ | Write short notes on XSU and JAVA? |
| ☺ | In which phase of mload can i use .FILLER? |
| ☺ | What is the family trees and connection by clause? |
| ☺ | What is the difference between case version and decode version? |
| ☺ | How to find the duplicate rows count from employees table in oracle? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
