SQL> DECLARE
  2    CURSOR cursMailingList IS
  3      SELECT INITCAP(c_first || ' ' || c_last || ' ' || c_address || ' ' || c_dphone)  AS STR
  4      FROM customer
  5      GROUP BY(c_first || ' ' || c_last || ' ' || c_address || ' ' || c_dphone);
  6    cursRow cursMailingList%ROWTYPE;
  7  BEGIN
  8    DBMS_OUTPUT.PUT_LINE('Clearwater Traders Mailing List');
  9    OPEN cursMailingList;
 10    FETCH cursMailingList INTO cursRow;
 11    LOOP
 12      EXIT WHEN cursMailingList%NOTFOUND;
 13      DBMS_OUTPUT.PUT_LINE(cursRow.STR);
 14      FETCH cursMailingList INTO cursRow;
 15    END LOOP;
 16    CLOSE cursMailingList;
 17  END;
 18  
 19  /
    GROUP BY(c_first || ' ' || c_last || ' ' || c_address || ' ' || c_dphone);
                                                                    *
ERROR at line 5:
ORA-06550: line 5, column 69:
PL/SQL: ORA-00904: "C_DPHONE": invalid identifier
ORA-06550: line 3, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 2, column 10:
PLS-00341: declaration of cursor 'CURSMAILINGLIST' is incomplete or malformed
ORA-06550: line 6, column 11:
PL/SQL: Item ignored
ORA-06550: line 10, column 30:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 10, column 3:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 26:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 13, column 5:
PL/SQL: Statement ignored
ORA-06550: line 14, column 32:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 14, column 5:
PL/SQL: SQL Statement ignored

SQL> desc customer
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 CUST_NAME                                 VARCHAR2(10 CHAR)
 DISTANCE                                  NUMBER
 PAYMENT                                   NUMBER
 REGULAR                                   NUMBER
 PROFILE_ID                                NUMBER

Set serveroutput on;
declare 
cursor cml is
select first, last, address, d_phone
from customers;
cus_row customers%rowtype;
Begin
for cus_row in cml loop
dbms_output.put_line(cus_row.first||' ' ||cus_row.last||' '||cus_row.address||' '||cus_row.d-phone)

end loop;
end;
/

DECLARE
    CURSOR cml IS
      SELECT first,
             last,
             address,
             d_phone
      FROM   customers;
    cus_row customers%ROWTYPE;
BEGIN
    FOR cus_row IN cml LOOP
        dbms_output.Put_line(cus_row.first
                             ||' '
                             ||cus_row.last
                             ||' '
                             ||cus_row.address
                             ||' '
                             ||cus_row.d_phone);
    END LOOP;
END;