Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Oracle Cursor statements – PB Docs 2019 – PowerBuilder Library

Oracle Cursor statements – PB Docs 2019

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


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x