CREATE OR REPLACE FUNCTION BuscaNome
  RETURN t_name
 IS
  t_name VARCHAR(20);
BEGIN

  SELECT T.DS_TURMA INTO t_name
   FROM TURMA T WHERE T.CD_TURMA = 13;

 RETURN t_name;
END;