[MDEV-16674] Document FOR loop Created: 2018-07-03  Updated: 2023-12-15

Status: Open
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: 10.4

Type: Task Priority: Major
Reporter: Alexander Barkov Assignee: Joe Cotellese
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
Relates
relates to MDEV-10580 sql_mode=ORACLE: FOR loop statement Closed
relates to MDEV-10581 sql_mode=ORACLE: Explicit cursor FOR ... Closed
relates to MDEV-12098 sql_mode=ORACLE: Implicit cursor FOR ... Closed
relates to MDEV-12314 sql_mode=ORACLE: Implicit cursor FOR ... Closed
relates to MDEV-14415 Add Oracle-style FOR loop to sql_mode... Closed

 Description   

We need a page explaining how to use the FOR loop, similar to what we have for WHILE:
https://mariadb.com/kb/en/library/while/

The new article should cover all FOR loop types:

  • Integer range FOR loop
  • Explicit cursor FOR loop
  • Implicit cursor FOR loop

and both syntax flavor:

  • SQL/PSM
  • Oracle's PL/SQL

 Comments   
Comment by Ian Gilfillan [ 2019-06-27 ]

To be added still:

  • Integer range FOR loop (Oracle mode)
  • Implicit cursor FOR loop (Oracle mode)
Comment by Julien Fritsch [ 2021-09-22 ]

jacob.moorman from our discussion, I decided to reassign Kenneth's ticket to you?

Generated at Thu Feb 08 08:30:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.