I have a table with two columns:

```
match_id varchar2(30)
timestamp

```

match\_id is in format of integer.[A|B], such as 1234.A, 1234.B, 1235.A or 1235.B. rows with match\_id on same integer is called a pair, so 1234.A and 1234.B is a pair while 1235.A and 1235.B is another pair.

Requirement is to delete all pairs if one row in this pair is older than certain timestamp. Database is Oracle 11.2 or higher.

I'm not good at SQL so any help is appreciated.