Write a PL/SQL using a cursor with Basic loop to update the Price attribute of all flight records in Flight table according to the following conditions: 1- If the FName is Oman Air, change price to...

 Write a PL/SQL using a cursor with Basic loop to update the Price attribute of all flight records in
Flight table according to the following conditions:
1- If the FName is Oman Air, change price to 500.
2-If the FName is Emirates, change price to 200.
3- If the FName is Air India, change price to 250.