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.