address varchar2(175)

[Shestakov]

SQL> select 'addr'||rpad('_',35-length('addr'),'_') field_val,
length('addr'||rpad('_',35-length('addr'),'_')) len from dual;

FIELD_VAL LEN
----------------------------------- ----------
addr_______________________________ 35

SQL>