SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Reference

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Reference
Author Message
tegrovesjr



Joined: 22 Mar 2007
Posts: 3

Post SQL Reference Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
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 View user's profile Send private message
tegrovesjr



Joined: 22 Mar 2007
Posts: 3

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.