Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Operator analogous to += or .= in PL/SQL?

I'd like to know whether there's an operator I could use in PL/SQL so that I could concatenate Strings with themselves, like what, for example we have in PHP:

$myStr .= "more text";

Which means: $myStr receives itself plus the string "more text".

like image 503
Felipe Avatar asked Nov 22 '11 18:11

Felipe


1 Answers

While I don't believe there are compound assignment operators in PL/SQL, the string concatenation operator is || so at least you can do this:

my_str := my_str || 'more text';
like image 161
BoltClock Avatar answered Nov 05 '22 06:11

BoltClock