 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
tegrovesjr
Joined: 22 Mar 2007 Posts: 3
|
|
SQL Reference |
|
I can't seem to find Loop, For Loop, or While Loop information in the Oracle SQL Reference. Is it hidden somewhere ?
|
|
Thu Mar 22, 2007 5:17 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Type keyword FOR in the editor then immediately press CTRL+F1. The required topic list for FOR keyword will popup below or above the cursor. In the list, click "Multi column for loop" continue from there as needed.
Another way is opening up the SQL Reference Index (for example, right-click menu in the editor, SQL Assistance item in the context menu, then SQL Reference sub-menu) Click on "Keyword Index" item to display the subitem list, click on the "For" keyword.
|
|
Thu Mar 22, 2007 5:55 pm |
|
 |
tegrovesjr
Joined: 22 Mar 2007 Posts: 3
|
|
|
|
I should have clarified. I'm looking for the keyword LOOP.
Should have found something like...
LOOP
i := i + 1;
...
IF i > 99 THEN
EXIT;
END IF;
END LOOP;
FOR record IN cursor
LOOP
...
END LOOP;
WHILE condition
LOOP
...
END LOOP;
|
|
Fri Mar 23, 2007 10:43 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I don't see the LOOP keyword in the index; looks like it is missing there. I will submit this as an enhancement request. I are going to start beta program for v2 pretty soon, I hope this change can make into that build.
|
|
Fri Mar 23, 2007 12:32 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|