SELECT 
       'UPDATE SAMPLE SET IDENTIFIER = '''
    || IDENTFIER
    || ''' WHERE ID='
    || SAMPLE.ID
  FROM (
      select 
      G.ID SAMPLE_GROUP_ID, 
      D.NAME IDENTFIER, 
      S.SAMPLE SAMPLE_NUMBER,
      ROW_NUMBER() OVER (partition by L.ID order by S.SAMPLE) CALCULATED_SAMPLE_NUMBER
      from
      SAMPLE_GROUP G, 
      PROTMS_DATAFILE D, 
      PROTMS_SOFTWAREANALYSIS S,
      PROTMS_LANE L
      WHERE L.ID = S.LANE_ID
      AND L.ID = G.LANE_ID
      AND S.DATAFILE_ID = D.ID
      ORDER BY L.ID, S.SAMPLE
  ) OLD_DATA, SAMPLE  
  WHERE 
    SAMPLE.SAMPLE_NUMBER    = OLD_DATA.CALCULATED_SAMPLE_NUMBER
    AND   SAMPLE.SAMPLE_GROUP_ID  = OLD_DATA.SAMPLE_GROUP_ID;

UPDATE SAMPLE SET SAMPLE_IDENTIFIER = (
  SELECT IDENTFIER FROM (
      select 
      G.ID SAMPLE_GROUP_ID, 
      D.NAME IDENTFIER, 
      S.SAMPLE SAMPLE_NUMBER,
      ROW_NUMBER() OVER (partition by L.ID order by S.SAMPLE) CALCULATED_SAMPLE_NUMBER
      from
      SAMPLE_GROUP G, 
      PROTMS_DATAFILE D, 
      PROTMS_SOFTWAREANALYSIS S,
      PROTMS_LANE L
      WHERE L.ID = S.LANE_ID
      AND L.ID = G.LANE_ID
      AND S.DATAFILE_ID = D.ID
      ORDER BY L.ID, S.SAMPLE
  ) OLD_DATA 
  WHERE SAMPLE.SAMPLE_NUMBER    = OLD_DATA.CALCULATED_SAMPLE_NUMBER
  AND   SAMPLE.SAMPLE_GROUP_ID  = OLD_DATA.SAMPLE_GROUP_ID
);