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 nu

[answerhappygod]

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]

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 Nu 1 (86.24 KiB) Viewed 18 times

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 Nu 2 (34.52 KiB) Viewed 18 times

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