Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE branch (nr, name) AS
SELECT 1, 'Aspen' FROM DUAL UNION ALL
SELECT 2, 'Beech' FROM DUAL UNION ALL
SELECT 3, 'Cedar' FROM DUAL;
3 rows affected

DECLARE
  CURSOR cursor_name IS
    SELECT nr, name FROM branch;
  no_rows BOOLEAN := TRUE;
BEGIN
  FOR i IN cursor_name LOOP
    DBMS_OUTPUT.PUT_LINE('Number: ' || to_char(i.nr) || ' Name: ' || i.name);
    no_rows := FALSE;
  END LOOP;

  IF no_rows THEN
    DBMS_OUTPUT.PUT_LINE('Table is empty');
  END IF;
END;
/
1 rows affected

dbms_output:
Number: 1 Name: Aspen
Number: 2 Name: Beech
Number: 3 Name: Cedar

DECLARE
  CURSOR cursor_name IS
    SELECT nr, name FROM branch;
  cursor_row cursor_name%ROWTYPE;
BEGIN
  OPEN cursor_name;
  
  FETCH cursor_name INTO cursor_row;
  IF cursor_name%NOTFOUND THEN
    DBMS_OUTPUT.PUT_LINE('Table is empty');
  END IF;
  
  LOOP
    EXIT WHEN cursor_name%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(
      'Number: ' || to_char(cursor_row.nr) || ' Name: ' || cursor_row.name
    );
    FETCH cursor_name INTO cursor_row;
  END LOOP;

  CLOSE cursor_name;
END;
/
1 rows affected

dbms_output:
Number: 1 Name: Aspen
Number: 2 Name: Beech
Number: 3 Name: Cedar

DELETE FROM branch;
3 rows affected

DECLARE
  CURSOR cursor_name IS
    SELECT nr, name FROM branch;
  no_rows BOOLEAN := TRUE;
BEGIN
  FOR i IN cursor_name LOOP
    DBMS_OUTPUT.PUT_LINE('Number: ' || to_char(i.nr) || ' Name: ' || i.name);
    no_rows := FALSE;
  END LOOP;

  IF no_rows THEN
    DBMS_OUTPUT.PUT_LINE('Table is empty');
  END IF;
END;
/
1 rows affected

dbms_output:
Table is empty

DECLARE
  CURSOR cursor_name IS
    SELECT nr, name FROM branch;
  cursor_row cursor_name%ROWTYPE;
BEGIN
  OPEN cursor_name;
  
  FETCH cursor_name INTO cursor_row;
  IF cursor_name%NOTFOUND THEN
    DBMS_OUTPUT.PUT_LINE('Table is empty');
  END IF;
  
  LOOP
    EXIT WHEN cursor_name%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(
      'Number: ' || to_char(cursor_row.nr) || ' Name: ' || cursor_row.name
    );
    FETCH cursor_name INTO cursor_row;
  END LOOP;

  CLOSE cursor_name;
END;
/
1 rows affected

dbms_output:
Table is empty