<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <AP_NAME>owl</AP_NAME>
  <AP_DESCRIPTION>Track feeding habits of owls.</AP_DESCRIPTION>
  <AP_VERSION>1.3</AP_VERSION>
  <DB_ID>3</DB_ID>
 </ROW>
 <ROW>
  <AP_NAME>finch</AP_NAME>
  <AP_DESCRIPTION>Track migration habits of finches.</AP_DESCRIPTION>
  <AP_VERSION>1.1</AP_VERSION>
  <DB_ID>1</DB_ID>
 </ROW>
 <ROW>
  <AP_NAME>robin</AP_NAME>
  <AP_DESCRIPTION>Track population statistics of robins.</AP_DESCRIPTION>
  <AP_VERSION>1.0</AP_VERSION>
  <DB_ID>2</DB_ID>
 </ROW>
</ROWSET>

CREATE TABLE  "APPLICATIONS" 
   (	"AP_ID" NUMBER(3,0) NOT NULL ENABLE, 
	"AP_NAME" VARCHAR2(25) NOT NULL ENABLE, 
	"AP_DESCRIPTION" VARCHAR2(4000), 
	"AP_VERSION" VARCHAR2(25) DEFAULT '1.0', 
	"DB_ID" NUMBER(3,0) NOT NULL ENABLE, 
	 CONSTRAINT "PK_APPLICATIONS" PRIMARY KEY ("AP_ID") ENABLE, 
	 UNIQUE ("AP_NAME") ENABLE, 
	 CONSTRAINT "APPLICATIONS_FK_DB_ID" FOREIGN KEY ("DB_ID")
	  REFERENCES  "DATABASES" ("DB_ID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "APPLICATIONS_TPK" 
BEFORE
insert on "APPLICATIONS"
for each row
begin
SELECT handsonxe06.ap_ids.nextval
INTO :new.ap_id
FROM dual;
end;
/
ALTER TRIGGER  "APPLICATIONS_TPK" ENABLE
/