Oracle Cursor statements

In embedded SQL, statements that retrieve data and statements that update data can both involve cursors.

Retrieval statements

The retrieval statements that involve cursors are:

  • DECLARE cursor_name CURSOR FOR ...

  • OPEN cursor_name

  • FETCH cursor_name INTO ...

  • CLOSE cursor_name

Update statements

The update statements that involve cursors are:

  • UPDATE ... WHERE CURRENT OF cursor_name

  • DELETE ... WHERE CURRENT OF cursor_name

PowerBuilder supports all Oracle cursor features.

See also

Oracle Cursor support summary

Oracle Retrieval

Oracle Update