// Таблица примера
CREATE TABLE tRoom (
  Room int NOT NULL,
  Row int NOT NULL,
  TableColor tinyint NOT NULL,
  DataColumn int NOT NULL,
  PRIMARY KEY (Room, Row, TableColor)
);

// Данные примера
INSERT INTO tRoom VALUES ( 1 ,  1 ,  1 ,  300 );
INSERT INTO tRoom VALUES ( 1 ,  1 ,  4 ,  600 );
// Дополнительные данные
INSERT INTO tRoom VALUES ( 1 ,  2 ,  2 ,  100 );
INSERT INTO tRoom VALUES ( 1 ,  2 ,  5 ,  200 );

COMMIT;

// Решение поставленной задачи
// (добавляем в таблицу примера все нехватающие цвета по Room=1 и Row=1)
INSERT INTO tRoom ON EXISTING SKIP WITH AUTO NAME
  SELECT  1  AS Room,  1  AS Row, g.row_num AS TableColor,  0  AS DataColumn
  FROM sa_RowGenerator( 1 ,  5 ) g;

COMMIT;

// Выводим результат
SELECT *
FROM tRoom
ORDER BY Room, Row, TableColor;

CREATE VIEW TableColors
AS
  SELECT  1  AS TableColor
  UNION ALL
  SELECT  2 
  UNION ALL
  SELECT  3 
  UNION ALL
  SELECT  4 
  UNION ALL
  SELECT  5 ;

INSERT INTO tRoom ON EXISTING SKIP WITH AUTO NAME
  SELECT r.Room, r.Row, g.row_num AS TableColor,  0  AS DataColumn
  FROM sa_RowGenerator( 1 ,  5 ) g
    CROSS JOIN (
      SELECT DISTINCT Room, Row
      FROM tRoom
    ) AS r

INSERT INTO tRoom (Room, Row, TableColor, DataColumn)
  SELECT r.Room, r.Row, g.TableColor,  0 
  FROM (SELECT  1  AS TableColor
        UNION ALL
        SELECT  2 
        UNION ALL
        SELECT  3 
        UNION ALL
        SELECT  4 
        UNION ALL
        SELECT  5 
      ) AS g,
      (SELECT DISTINCT Room, Row
       FROM tRoom) AS r
  WHERE NOT EXISTS(
          SELECT *
          FROM tRoom
          WHERE Room = r.Room AND
                Row = r.Row AND
                TableColor = g.TableColor);