Create the database objects for this chapter before you start by using a script provided. The code comes with the following readme file: readme_3_1.txt
.
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. For all of the database objects there is a script provided called 4842_03_01.sh
. The following section provides details of how to run the script.
To create the database objects, perform the following steps:
1. Create a local directory
C:\packt\scripts\ch3
where the scripts are downloaded to.2. Open Putty and connect to the application tier user.
3. Create a new directory on the application tier under
$XXHR_TOP/install
with the following commands:cd $XXHR_TOP/install mkdir ch3
4. Navigate to the new directory...