concatenating in forms

[Guest_imported]

does anyone know how to contenate in forms?
I have a code:
select name into first_name||''||middle_name||''||last_name
from mytable.
Forms is not recognizing that concatenation.
Please show me if you know.
Thanks,
johntu

 

[sem]

You can not concatenate destination variables. Not only Forms but no tools at all can recognize your query . You should probably intergange source and destination if first_name, middle_name and last_name are table fields and you need to concatenate them to store into a single variable NAME.