address varchar2(175)

[aph]

Hi,
I have a table and column name is address varchar2(175).
I am developing a developer/2000 Form and I wants to display 5 lines with the width 35 instead of 1 line.
e.g
Addr1__________________
Addr2__________________
Addr3__________________
Addr4__________________
Addr5__________________


Please help me to resolve this.
Thanks.

[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>

[aph]

Hi,
Where I will type this SQL?

[sree_sri]

select
substr(address,1,35),
substr(address,36,75),
substr(address,76,105),
substr(address,106,140),
substr(address,141,175)

into :block.addr1,:block.addr2,:block.addr3,:block.addr4,:block.addr5

from table;

For example you have a form with 5 columns, And one button called
"Find".

right Click on find button and select plsql and select
"when button pressed" trigger and write this sql in that.
put "begin" at the sql code front and "end" at the last.

When ever you click the button, The plsql code will retrieve the data
into the 5 address fields, In above sql code change ":block." with
your block name.

Good Luck.

Sree.