ORACLE PLSQL - LOOP

1. CREATE INDEX
2. DECODE
3. TO_CHAR
4. TO_DATE
5. SELECT
6. GRANT
7. INSERT
8. TUNNING
9. UPDATE
10. CREATE USER

LOOP

	LOOP
	   ;
	END LOOP;

	LOOP
	   EXIT WHEN ;
	END LOOP;

	LOOP
	   IF  THEN
	      EXIT;
	   END IF;
	END LOOP;

	FOR  IN 1 .. 10 LOOP
	
	END LOOP;

	FOR i IN 1 .. 10 LOOP
	
	   FOR j IN 1 .. 10 LOOP
	
	      EXIT outer WHEN ;
	   END LOOP;
	END LOOP outer;

	declare
	x number;
	r varchar(100);
	begin
	case 
	   WHEN x=1 THEN r:='aa';
	
	   WHEN x=2 THEN r:='bb';
	
	   ELSE r:='cc';
	
	END CASE;
	end;