Databases Reference
In-Depth Information
Category
Convention
Description
synonyms providing.sql
Synonyms (providing)
These are the private or public synonyms that
our application provides.
<object name>
drop.sql
Drop scripts
For the sake of transparency, we separate the
drop scripts from the creation scripts of all
objects.
The patch script
patch
<db schema>
.sql
is the script, where all other scripts are registered and run
in the correct order. For example, in the patch script in Listing 9-10 we add a column to the table
FM BOOKINGS
, add the same column to the view
FM BOOKINGS V,
and finally update the source code in the
package
FM BOOKING
.
Listing 9-10.
Patch Script
patch fm.sql
/*=========================================================================
$Id: patch.sql 701 2011-03-06 11:09:48Z aust.dietmar $
Purpose : Patch script to install a release for the application
facility management
$LastChangedDate: 2011-03-06 12:09:48 +0100 (Su, 06 Mar 2011) $
$LastChangedBy: aust.dietmar $
Date Author Comment
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
06.03.2011 D. Aust Initial creation
=========================================================================*/
set define '^'
set timing on
set pagesize 50000
set linesize 80
set serveroutput on size unlimited
--#########################
define VERSION=1.0.0.3
--#########################
spool patch fm v^VERSION..log
@@lib/ require user FM
@@lib/ patch start
-----------------------------------------------------------------------------
set define off
prompt **********************************************************************
prompt ** Sequences
prompt **********************************************************************