Sample Database Inserts

The following are the inserts used to demo the Add Role use case:

INSERT INTO prc_names (id, family_name, given_name)
 VALUES (prc_names_seq.NEXTVAL, 'Rock', 'Chris');

INSERT INTO prc_names (id, family_name, given_name)
 VALUES (prc_names_seq.NEXTVAL, 'Fey', 'Tina');


INSERT INTO prc_persons
   (id, date_of_birth, gender, official_name_id, preferred_name_id)
 (SELECT prc_persons_seq.NEXTVAL, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 'M',
    n.id, n.id
      FROM prc_names n
        WHERE  n.family_name = 'Rock');

INSERT INTO prc_persons
   (id, date_of_birth, gender, official_name_id, preferred_name_id)
 (SELECT prc_persons_seq.NEXTVAL, TO_DATE('20-MAR-1975', 'DD-MON-YYYY'), 'F',
    n.id, n.id
      FROM prc_names n
        WHERE  n.family_name = 'Fey');