Create the database objects for this chapter before you start by using a script provided called 4842_02_01.sh
. We are going to create a table, a view, and a 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 following recipe provides details of how to run the script.
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.3. Create a new directory on the application tier under
$XXHR_TOP/install
using the following commands:cd $XXHR_TOP/install mkdir ch2
4. Navigate to the new directory
cd ch2
using the following command:cd ch2
5. Open WinSCP and FTP the...