Oracle Cursor statements – PB Docs 126

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 12.6
  5. Oracle Cursor statements – PB Docs 126

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

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 12.6
and Functions Events Objects and Controls PB Docs 126 PowerBuilder .NET Powerbuilder Documentation Powerbuilder Documentation 12.6 Powerbuilder Documentation Older PowerBuilder Extension Reference PowerBuilder New Features 12.6 PowerDesigner Integration System Object Properties Using the ADO.NET Interface
August 14, 2023
Was this article helpful?
0
0
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x