In a loop I want to increment the last character which is a number as follows.
In the first loop the string will have a value of ABC_1. In the second loop it should have a value of ABC_2 until ABC_10.
Here is my code which does not work as I expect. Any help will be appreciated. Thank you!
v_cnt NUMBER (2) := 0;
v_name VARCHAR2 (50) := 'ABC_';
LOOP
v_cnt := v_cnt + 1;
EXIT WHEN v_cnt > 10;
v_name := v_name || v_cnt;
DBMS_OUTPUT.put_line ('v_name - ' || v_name);
END LOOP;