as oracle database cannot use distinct modifier on clob columns some
statments must be adjusted so they don not fail on oracle database