  | 
			
				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: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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
  | 
   
 
		 | 
	 
	  |