|
Ispirer SQLWays Database Migration Software
Cursor Declaration Conversion from Microsoft SQL Server to Oracle
a) Converting the FORWARD_ONLY cursor
The FORWARD_ONLY option in Microsoft SQL Server specifies that rows scrolled in forward direction from the first to the last row. This scrolling is default in Oracle, so the FORWARD_ONLY option is removed by SQLWays.
Examples:
b) Converting SCROLL cursor
The SCROLL option in Microsoft SQL Server specifies that rows scrolled in various directions (FIRST, LAST, PRIOR, NEXT, RELATIVE, ABSOLUTE). Whereas Oracle supports only forward direction (NEXT).
SQLWays removes the SCROLL option when converting to Oracle. This declaration conversion is correct if an application uses fetch with NEXT, otherwise the application must be revised.
Examples: