Oracle/PLSQL While Loop

发布时间：2020-12-12 13:20:29 所属栏目：百科来源：网络整理

导读：? Oracle/PLSQL: While Loop ? The syntax for the WHILE Loop is: WHILE condition LOOP ???? {.statements.} END LOOP; You would use a WHILE Loop when you are not sure how many times you will execute the loop body. Since the WHILE condition is

? Oracle/PLSQL: While Loop ? The syntax for the WHILE Loop is: WHILE condition
LOOP
???? {.statements.}
END LOOP; You would use a WHILE Loop when you are not sure how many times you will execute the loop body. Since the WHILE condition is evaluated before entering the loop,it is possible that the loop body may not execute even once. 译：当你不确定循环体有多少次的时候，可以使用 WHILE LOOP 。因为在进入循环以前， WHILE 的条件是先给的，因为可能循环体不止执行一次。 Let‘s take a look at an example: WHILE monthly_value <= 4000
LOOP
???? monthly_value := daily_value * 31;
END LOOP; In this example,the WHILE Loop would terminate once the monthly_value exceeded 4000. 译：在该示例中，WHILE循环将会在 monthly_value 的值达到 4000 时终止。 ?

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!