Oracle Dialect

Limitations

• Only Oracle 12 supported (limit with FETCH ... ROWS ONLY)
• autoinc columns supported by sequences, need an argument with sequence name
• insert with select with limit not supported (DMLTests.testInsertSelect01)

Running tests locally with Gradle

• Set dialect in gradle.properties to 'oracle'
• Run exposedDialectTestWithDocker gradle task

Running tests locally with Docker

• Run SQL Server locally, e.g. with sath89/oracle-12c Docker image or use docker-compose -f docker-compose-oracle.yml up
• Run tests with -Dexposed.test.dialects=oracle, (optionally you may need to provide -Dexposed.test.oracle.host=_YOUR_DOCKER_HOST_ -exposed.test.oracle.port=_SQLSERVER_SERVER_EXPOSED_PORT_)