DECLARE
  CURSOR t_data
  IS
    SELECT s.name FROM ships s ORDER BY S.Name DESC;

BEGIN
  OPEN t_data;
  LOOP
    FETCH t_data INTO v_ships_names;
 EXIT
  WHEN t_data%notfound;
  END LOOP;

 CURSOR t_data_o
  IS
    SELECT o.battle FROM outcomes o WHERE o.ship IN ( намименования кораблей (s.name) );

SET serveroutput ON;
DECLARE
  CURSOR t_data
  IS
    SELECT s.name FROM ships s ORDER BY S.Name DESC;
  v_ships_names VARCHAR2(250);
TYPE ship_variable
IS
  TABLE OF VARCHAR2(128) INDEX BY BINARY_INTEGER;
  names_ships ship_variable;
  q INTEGER := 0;
  CURSOR t_data_o
  IS
    SELECT o.battle FROM outcomes o WHERE o.ship IN (names_ships(22));
BEGIN
  OPEN t_data;
  LOOP
    FETCH t_data INTO v_ships_names;
    q := q + 1;
    names_ships(q) := v_ships_names;
    EXIT
  WHEN t_data%notfound;
  END LOOP;
  CLOSE t_data;
  FOR cur_rec IN t_data_o
  LOOP
    Dbms_Output.Enable;
    dbms_output.put_line (cur_rec.battle);
  END LOOP;
END;

SELECT o.battle FROM outcomes o WHERE o.ship IN (SELECT name FROM ships);