Category: Example

You can create a PL/SQL block to calculate and display the average salary of employees in a specific department:

To delete an employee record with a specific employee_id:

To update the salary of employees in department 1 by a 10% raise:

To retrieve all employees in a specific department with a salary greater than $60,000, use the following query:

Next, insert some sample employee records:

First, create the employees table with various fields: