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'))