add enum for the dialect
using dialect to do insert
add oracle dialect select id, need to be tested