First, install Oracle Database 11g XE (http://www.oracle.com/technetwork/products/express-edition/overview/index.html). In this section, we shall create a database table in Oracle database 11g XE. Run the following SQL script in the SQL command line to create a database table Catalog
. The Catalog
database table contains Catalog
entries for a journal as follows:
CREATE TABLE Catalog(CatalogId VARCHAR(255), Journal VARCHAR(255), Publisher Varchar(255), Edition VARCHAR(255), Title Varchar(255), Author Varchar(255)); INSERT INTO Catalog VALUES('catalog1', 'Oracle Magazine', 'Oracle Publishing', 'September-October 2010', 'Using Oracle Essbase Release 11.1.2 Aggregate Storage Option Databases', 'Mark Rittman and VenkatakrishnanJanakiraman'); INSERT INTO Catalog VALUES('catalog2', 'Oracle Magazine', 'Oracle Publishing', 'July-August 2010', 'Infrastructure Software and Virtualization', 'David Baum');
Install Oracle Enterprise Pack for Eclipse 12c using Installers with...