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:

TABLE 33. Cursor declaration statements in various databases

Microsoft SQL Server	Oracle
DECLARE cur1 CURSOR FORWARD_ONLY FOR SELECT col1 FROM tab1	CURSOR cur1 IS SELECT col1 FROM tab1;

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:

TABLE 34. Converting SCROLL cursor

Microsoft SQL Server	Oracle
DECLARE cur1 CURSOR SCROLL FOR SELECT col1 FROM tab1	CURSOR cur1 IS SELECT col1 FROM tab1;