Example of control statements in Oracle

Declare Grade varchar2 (2 ); Begin Grade: = '& Grade' ; Case      When Grade = 'A'   Then Dbms_output.put_line ( 'Excellent' ); When Grade = 'B'   Then Dbms_output.put_line ( 'Excellent' ); When Grade = 'C'   Then Dbms_output.put_line ('Good' ); When Grade = 'D'   Then Dbms_output.put_line ( 'Average' ); When Grade = 'E'   Then Dbms_output.put_line ( 'Bad' ); Else Dbms_output.put_line ( 'No score' ); End   Case ; End ;/ Begin Loop If & Amp; marks> 60 Then Dbms_output.put_line ( 'The student passed' ); Exit ; End   If ; End Loop; End ;/ Declare Monthly_value number: = 0; daily_value number: = 0; Begin    While Monthly_value <= 4000 loop monthly_value: = daily_value * 31; daily_value: = daily_value + 10; dbms_output.put_line ( 'Daily sales volume :' | Daily_value ); End Loop; dbms_output.put_line ( 'Monthly sales volume :' | Monthly_value ); End ;