This table shows the equivalent Microsoft® SQL Server™ function for each Oracle function.
| Function | Oracle | SQL Server |
|---|---|---|
| Return first nonnull expression | DECODE | COALESCE |
| Current sequence value | CURRVAL | N/A |
| Next sequence value | NEXTVAL | N/A |
| If exp1 = exp2, return null | DECODE | NULLIF |
| User’s login ID number | UID | SUSER_ID |
| User’s login name | USER | SUSER_NAME |
| User’s database ID number | UID | USER_ID |
| User’s database name | USER | USER_NAME |
| Current user | USER | USER |
| User environment (audit trail) | USERENV | N/A |
| Level in CONNECT BY clause | LEVEL | N/A |