![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
Microsoft SQL Server and Oracle Functions and Expressions
This chapter provides detailed descriptions of the differences in functions and expressions used by Microsoft SQL Server and Oracle databases.
In Oracle, DECODE expressions are used to easily manipulate the data representation of a table. SQLWays converts Oracle DECODE expressions to SQL Server simple CASE expressions.
For example, this query decodes the value DEPTNO. If DEPTNO is 10, the query returns 'ACCOUNTING'; if DEPTNO is 20, it returns 'RESEARCH'; etc. If DEPTNO is not 10, 20, 30, or 40, the query returns 'NONE'.
For more information, see Oracle DECODE Expressions and Microsoft SQL Server Simple CASE Expressions
![]() ![]() ![]() |