Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle - SQL Functions Mapping to Other Databases
Numeric Functions Mapping
| Oracle | SQL Server | IBM DB2 | MySQL |
|---|---|---|---|
| ABS | ABS | ABS | ABS |
| ACOS | ACOS | ACOS | ACOS |
| ASIN | ASIN | ASIN | ASIN |
| ATAN | ATAN | ATAN | ATAN |
| ATAN2 | ATN2 | ATAN2 | ATAN2 |
| BITAND | |||
| CEIL | CEILING | CEILING | CEILING |
| COS | COS | COS | COS |
| COSH | COSH | ||
| EXP | EXP | EXP | EXP |
| FLOOR | FLOOR | FLOOR | FLOOR |
| LN | LOG | LN | LN |
| LOG | LOG10 | LOG10 | LOG10 |
| MOD | MOD | MOD | |
| NANVL | |||
| POWER | POWER | POWER | POWER |
| REMAINDER | |||
| ROUND (number) | ROUND | ROUND | ROUND |
| SIGN | SIGN | SIGN | SIGN |
| SIN | SIN | SIN | SIN |
| SINH | SINH | ||
| SQRT | SQRT | SQRT | SQRT |
| TAN | TAN | TAN | TAN |
| TANH | TANH | ||
| TRUNC (number) | TRUNCATE | TRUNCATE |