![]() ![]() In this case, index is set to lower_bound, the statements execute, and control returns to the top of the loop, where index is compared to upper_bound. Typically, lower_bound is less than upper_bound. If you modify the values of lower_bound or upper_bound inside the loop, the change will have no effect because they are evaluated once only before the first loop iteration starts. The results of lower_bound and upper_bound are rounded to the nearest integer if necessary. Their values are stored as temporary PLS_INTEGER values. The lower_bound and upper_bound are evaluated once when the FOR LOOP statement starts. After the FOR LOOP statement executes, the index becomes undefined.īoth lower_bound and upper_bound are numbers or expressions that evaluate to numbers. ![]() Inside the loop, you can reference index but you cannot change its value. In other words, you cannot reference it outside the loop. Code language: SQL (Structured Query Language) ( sql ) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |