--------------------------------------------------------
--  File created - Friday-December-09-2016   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table COUNTRIES
--------------------------------------------------------

  CREATE TABLE "COUNTRIES" 
   (	"COUNTRY_ID" CHAR(2), 
	"COUNTRY_NAME" VARCHAR2(40), 
	"COUNTRY_SUBREGION" VARCHAR2(30), 
	"COUNTRY_REGION" VARCHAR2(20)
   ) ;

REM INSERTING into COUNTRIES
SET DEFINE OFF;
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('US','United States of America','Northern America','Americas');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('DE','Germany','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('UK','United Kingdom','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('NL','The Netherlands','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('IE','Ireland','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('DK','Denmark','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('FR','France','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('ES','Spain','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('TR','Turkey','Western Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('PL','Poland','Eastern Europe','Europe');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('BR','Brazil','Southern America','Americas');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('AR','Argentina','Southern America','Americas');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('MY','Malaysia','Asia','Asia');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('JP','Japan','Asia','Asia');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('IN','India','Asia','Asia');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('AU','Australia','Australia','Oceania');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('NZ','New Zealand','Australia','Oceania');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('ZA','South Africa','Africa','Africa');
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_REGION) values ('SA','Saudi Arabia','Middle East','Middle East');
--------------------------------------------------------
--  DDL for Index COUNTRY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "COUNTRY_PK" ON "COUNTRIES" ("COUNTRY_ID") 
  ;
--------------------------------------------------------
--  Constraints for Table COUNTRIES
--------------------------------------------------------

  ALTER TABLE "COUNTRIES" MODIFY ("COUNTRY_NAME" CONSTRAINT "COUNTRY_COUNTRY_NAME_NN" NOT NULL ENABLE);
  ALTER TABLE "COUNTRIES" ADD CONSTRAINT "COUNTRY_PK" PRIMARY KEY ("COUNTRY_ID") RELY
  USING INDEX  ENABLE;
