Sunday 11 May 2014

Difference between Case and Decode



Decode
Case
It can use only scalar values
It can use logical operator, predicates, and searchable sub queries.
It can be used in SQL statement
It can be used in PLSQL
Decode is proprietary to Oracle
It is compile with ANSI SQL
Decode is a function
It is a statement


1 comment:

  1. Best Best Bitcoin casino - Xn Spades - xn--o80b910a26eepc81il5g.online
    The Best Bitcoin casino. XnSpades 메리트카지노총판 is a well-known Bitcoin casino. The game offers a unique experience for online gambling that is enjoyed

    ReplyDelete