Appending strings in Oracle within a plsql loop

Question

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

Chandu · Accepted Answer · 2011-06-23 17:47:16Z

30

Concatenation operator is || However, there is not short form of the concatenation that you are looking for (i.e. +=).

You can try this:

DECLARE
 lvOutPut VARCHAR2(2000);
BEGIN
    lvOutPut := 'BLA';
    FOR i in 1..10 LOOP
        lvOutPut := lvOutPut || i;
    END LOOP;
    DBMS_OUTPUT.PUT_LINE(lvOutPut);
END;

edited Jun 23, 2011 at 17:47

answered Jun 23, 2011 at 15:25

Chandu

83.2k19 gold badges136 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

help Over a year ago

Ah thanks. Sometimes I just assume =+ is a default within any program language. Was going to use the long hand method of that.

Collectives™ on Stack Overflow

Appending strings in Oracle within a plsql loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related