Branch statement/Loop statement
V_case Number(3) := -;begin if 2 < 1 ThenDbms_output.put_line ('conditions established'); elsif4 > 3 Then if 7 < 6 ThenDbms_output.put_line ('condition not established 1'); End if; elsif6 > 5 ThenDbms_output.put_line ('condition not established 2'); ElseDbms_output.put_line ('condition not established 3'); End if; CaseV_case when 1 ThenDbms_output.put_line ('conditions established 1'); when - ThenDbms_output.put_line ('conditions established'); ElseDbms_output.put_line ('conditions do not match'); End Case; Case when 8 > 7 ThenDbms_output.put_line ('8 > 7 established'); when 9 > 8 ThenDbms_output.put_line ('9 > 8 established'); ElseDbms_output.put_line ('It 's not true .'); End Case; <<Loop1>>Loop v_case:=V_case- 1; Dbms_output.put_line ('v_case =' ||v_case); --if (v_case =) Then --dbms_output.put_line (' exit cycle '); ExitLoop1 whenV_case= -; --End If; EndLoop; whileV_case> theLoop v_case:=V_case- 1; Dbms_output.put_line ('v_case =' ||v_case); EndLoop; forInxinch Reverse 1..TenLoop v_case:=V_case+Inx; Dbms_output.put_line ('v_case =' ||v_case); EndLoop;EndPr_test1;/
Oracle Process Control Statement collation