Introduction

[Marley]

[Marley]

Course Practices

When you perform the practices in the course, you develop a simple application using an anonymous block. This anonymous block covers the following:

Writing a declarative section
Declaring variables of scalar types
Declaring variables using the %TYPE attribute
Writing an executable section
Accepting user inputs for variables
Retrieving the values from the database and storing the values in the variables by using the INTO clause
Writing a nested block within the executable section
Using the control structures in the executable section to perform business logic
Using the INDEX BY table to store values and print them
Handling exceptions


What Is the Functionality of This Application?

This application is a simple HR application, and only employees working in the Human Resources department are authorized to use it. In the employees table, only one employee is in the HR department. Therefore, you can use employee_id for authentication.

The company has decided to provide salary raises to employees in certain departments this quarter. The raise percentages are determined by the employees current salaries.