I just found the following in someone else's PL/SQL program:
First of many, I'm sure. I'll try to remember to report here the first time I do it.
For those of you who may not be fluent in PL/SQL, the above is functionally equivalent to:
:= p_item_segment1 || '.' ||
A rough Perl translation of the latter would be:
$lv_item_number = join('.',
A rough Perl translation of the former would require loading DBI and sending your two values to the database to be joined in SQL.