By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE your_table_name (
m_id NUMBER,
name VARCHAR2(255),
ind NUMBER
);
INSERT INTO your_table_name (m_id, name, ind)
VALUES
(1, 'John', 1),
(1, 'John', 2),
(2, 'Alice', 1),
(2, 'Alice', 2),
(3, 'Acinit', 1),
(3, 'Acinit', 3),
(3, 'Acinit', 2),
(4, 'Test', 1);
8 rows affected
Select * from your_table_name
| M_ID | NAME | IND |
|---|---|---|
| 1 | John | 1 |
| 1 | John | 2 |
| 2 | Alice | 1 |
| 2 | Alice | 2 |
| 3 | Acinit | 1 |
| 3 | Acinit | 3 |
| 3 | Acinit | 2 |
| 4 | Test | 1 |