PL/SQL LOOP USING QUERT

DECLARE
  n number := 0;
  cursor c_data is
    SELECT coloumn FROM table; -- Your query here
BEGIN
  FOR data_row IN c_data LOOP
    n := n + 1;
    DBMS_OUTPUT.PUT_LINE('Row ' || n || ': ' || data_row.column_name);
  END LOOP;
END;