Into more columns
Thu Sep 23 2021 01:06:56 GMT+0000 (Coordinated Universal Time)
Saved by
@kaveen
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;
content_copyCOPY
Comments