Answer Happy

1-Write Pl/SQL code to show the Tax for Commercial Company where

Tax = 0.12 * Profit
2- Write Pl/SQL code to check a number status ( Odd or Even )
3- Write Pl/SQL code to print the odd numbers in the range from 5 to 25
4- Write Pl/SQL code to find the maximum of two values by using procedure technique
5- For a given table including named employee including field ( ID, Name , Dept. ,Salary , address )

Write Pl/SQL code to Delete the employee data who works in Quality assurance Dept. and print the number of the selected rows Hint [Use Cursor technique]
Question 1 Write PI/SQL code to show the Tax for Commercial Company where Tax = 0.12 * Profit Answer Question 2 Write PI/SQL code to check a number status ( Odd or Even ) Answer Question 3 Write PI/SQL code to print the odd numbers in the range from 5 to 25 Answer Questions Write PI/SQL code to find the maximum of two values by using procedure technique Answer

Question For a given table including named employee including field (ID, Name , Dept. „Salary , address ) Write PI/SQL code to Delete the employee data who works in Quality assurance Dept. and print the number of the selected rows Hint (Use Cursor technique] Answer