Appending strings in Oracle within a plsql loop

Viewed 47351

Like any programming language you can use a simple =+ to append to a variable string, but how do you do that within an Oracle PlSql block?

Example

my_string string

my_string = 'bla';

while ...(not greater than 10)
my_string += 'i';

expected output: bla12345678910

1 Answers
Related