dokuwiki

CREATE TABLE  "PARTICIPANT" 
   (	"PAR_ID" NUMBER NOT NULL ENABLE, 
	"PAR_NAME" VARCHAR2(20) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PAR_DATE_OF_BIRTH" DATE, 
	 CONSTRAINT "PARTICIPANT_PK" PRIMARY KEY ("PAR_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "PARTICIPANT_PAR_NAME_UQ" UNIQUE ("PAR_NAME")
  USING INDEX  ENABLE
   );

REM INSERTING into HR.PARTICIPANT
SET DEFINE OFF;
Insert into HR.PARTICIPANT (PAR_ID,PAR_NAME,PAR_DAY_OF_BIRTH) values (1,'Mark',to_date('23.02.75','DD.MM.RR'));
Insert into HR.PARTICIPANT (PAR_ID,PAR_NAME,PAR_DAY_OF_BIRTH) values (2,'Robert',to_date('02.04.79','DD.MM.RR'));
Insert into HR.PARTICIPANT (PAR_ID,PAR_NAME,PAR_DAY_OF_BIRTH) values (1237,'Peter',to_date('17.07.64','DD.MM.RR'));
Insert into HR.PARTICIPANT (PAR_ID,PAR_NAME,PAR_DAY_OF_BIRTH) values (1238,'Sandra',to_date('22.02.94','DD.MM.RR'))