Short and Easy Pl/SQL Query Work

1- Create a PL/SQL block that finds the maximum salary of employees in department 10 and stores it in v_max_sal variable. Display this value. Maximum salary in department 10 is 4400 2- Write a SQL statement to create a new table, named cpy_dept, that is a copy of the departments table. Display the data in this table using a SELECT statement (should be the same data as in departments). 3- Create a PL/SQL block that modifies the data in cpy_dept: - delete the row with department ID 10. Show a message indicating how many rows have been deleted. - In the same block, for any department located at location 1700, change the manager ID to 100. Show a message indicating how many rows were updated. - Run the block and display the data in this table using a SELECT statement. 1 row deleted. 3 row(s) updated. 4- Create a PL/SQL block that merges the department table into cpy_dept, updating cpy_dept. Make sure you are NOT modifying the departments table. Run the block and display the data in cpy_dept table using a SELECT statement.