pl/sql

DECLARE

SupplierName   s.sname%TYPE;  -- %type: go to DB and
SupplierStatus s.status%TYPE; -- find out exact type

BEGIN
SELECT sname,status
INTO SupplierName, SupplierStatus
FROM s
WHERE snum = 'S4';

DBMS_OUTPUT.put_line('Supplier Name is '||
SupplierName || '; status is '|| SupplierStatus);
-- the || symbol stands for 'concatenate'. Used
-- with strings the way other languages use
-- '+' (javascript) or '&' (VB) or '.' (perl)
END;