@Override
    public String getCastTypeNameForCode(int code) {
        switch (code) {
            case Types.DOUBLE:   return "double precision";
            case Types.VARCHAR:  return "varchar(4000 char)";
            default: return super.getCastTypeNameForCode(code);
        }
    }
{@code OracleTemplates} is an SQL dialect for Oracle

<p>tested with Oracle 10g XE</p>

@author tiwe
querydsl-sql/src/main/java/com/querydsl/sql/OracleTemplates.java