Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > CREATE TABLE table1 > ( > my_count INTEGER, > my_type VARCHAR (10), > count INTEGER, > type VARCHAR (10) > ); > > <pre> > ✓ > </pre> <!-- --> > INSERT INTO table1 VALUES (1, 'type1', 34, 'type1_bis'); > > <pre> 1 rows affected > </pre> <!-- --> > INSERT INTO table1 VALUES (2, 'type2', 45, 'type2_bis'); > > <pre> 1 rows affected > </pre> <!-- --> > INSERT INTO table1 VALUES (3, 'type3', 45, 'type3_bis'); > > <pre> 1 rows affected > </pre> <!-- --> > INSERT INTO table1 VALUES (4, 'type4', 67, 'type4_bis'); > > <pre> 1 rows affected > </pre> <!-- --> > INSERT INTO table1 VALUES (5, 'type5', 78, 'type5_bis'); > > <pre> 1 rows affected > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=3b4af1df6b71cb8c2602e5903c83820a)*
back to fiddle