Rem  Copyright (c) Oracle Corporation 2014. All Rights Reserved.
Rem
Rem    NAME
Rem      ords_version.sql
Rem
Rem    DESCRIPTION
Rem      This script creates an internal view that stores the ORDS product version
Rem      Do not invoke this script directly.  If you are doing a manual installation, use ords_manual_install.sql
Rem
Rem    NOTES
Rem      Assumes ORDS schema user is connected.
Rem
Rem    REQUIREMENTS
Rem      - Oracle Database Release 11.1 or later
Rem
Rem    Arguments:
Rem      1  : Version installed for ORDS
Rem
Rem    MODIFIED    (MM/DD/YYYY)
Rem     cdivilly    09/18/2014 - Created.
Rem
Rem

set define '^'
set verify off
set termout on
set autocommit off

define INSTALLTYPE  = '^1'
define CURRVERSION  = '^2'

create or replace view ords_version as select '^CURRVERSION' version from dual;