CREATE OR REPLACE PROCEDURE concatenate_strings as

str1 VARCHAR2(10) := 'begin';

str2 VARCHAR2(10) := 'end';

result VARCHAR2(20);

BEGIN

result := str1 || ' ' || str2;

dbms_output.put_line('The result is' || result);

END;

/

SET SERVEROUTPUT ON;

EXECUTE concatenate_strings;

Write a function that will do the same as concatenate_strings procedure from #1, but can be called from a select statement. Examples of output