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;
Preview:
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