Preview:
DECLARE 
var_cname varchar(40);
var_address varchar(40);
Var_clno int := 3;
BEGIN
	SELECT c.NAME,c.Address
        INTO var_cname,var_address
	FROM CUSTOMERS c
	WHERE c.ID = var_clno;
	
	DBMS_OUTPUT.PUT_LINE('Name of the client with clno:' || var_clno || 'is ' || var_cname || ' - Address' || var_address);
END;
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter