SQL>
SQL>
SQL>
SQL> declare
2 v VARCHAR2(50):= 'I just printed my <in> line!';
3 procedure p_print(i_string in VARCHAR2, i_replace in VARCHAR2 := 'new') is
4 begin
5 DBMS_OUTPUT.put_line(replace(i_string,'<in>', i_replace));
6 end;
7 begin
8 p_print (v,'first');
9 p_print (v,'second');
10 p_print (v);
11 end;
12 /
I just printed my first line!
I just printed my second line!
I just printed my new line!
PL/SQL procedure successfully completed.
SQL>
|