Answers for "for oracle"

SQL
0

for loop oracle

-- FOR LOOP --------------
  FOR loop_counter IN [REVERSE] lowest_number..highest_number
  LOOP
     {...statements...}
  END LOOP;
  
-- FOR LOOP (MODERN) --------------
  FOR record_index in cursor_name
  LOOP
  {...statements...}
  END LOOP;
  
-- CURSOR LOOP (OLD STYLE) --------------
	OPEN c_customers; 
    LOOP 
    	FETCH c_customers into c_rowtype_var; 
    	EXIT WHEN c_customers%notfound; 
    	{...statements...}; 
    END LOOP;
Posted by: Guest on March-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language