  DECLARE
  cname country.name%TYPE;
  BEGIN
   SELECT name
   INTO cname
   FROM country
   WHERE code='D';
   dbms_output.put_line(cname);
  END;
  /
