@Test
    public void testGetGeneratedKeys() throws Exception {
        oracleExtension.getJdbi().useExtension(DAO.class, dao -> {
            Long fooId = dao.insert("Foo");
            long barId = dao.insert("Bar");

            assertThat(dao.findNameById(fooId)).isEqualTo("Foo");
            assertThat(dao.findNameById(barId)).isEqualTo("Bar");
        });
    }
Oracle needs to be queried by index and not id (like {@code DefaultGeneratedKeyMapper}
does).
oracle12/src/test/java/org/jdbi/v3/oracle12/TestGetGeneratedKeysOracle.java