Installing the database objects

Create the database objects for this chapter before you start, by using a script provided called 7126_02_01.sh.

Getting ready

We are going to create a table, view, and synonym for the new block we will create. We will also create a package that will handle all of the database transactions, such as insert, update, and delete. Finally, we will create a sequence that will be used to generate a unique number for new records. The next section provides details of how to run the script.

Tip

Create XXHR schema

If you have not done so already, create a new custom schema called XXHR. Please refer to Chapter 8, Utilities to create the schema if you have not done so already before running the database installation script given in the next section.

How to do it...

To create the database objects required for this chapter, perform the following tasks:

1. Create a local directory c:\packt\scripts\ch2, where the scripts are downloaded and extracted to.

2. Open Putty and connect to the...