SQL> ed
Wrote file afiedt.buf

  1  declare
  2  v_dept dept%ROWTYPE;
  3  begin
  4      select * into v_dept from dept where deptno=10;
  5  dbms_output.put_line(v_dept.deptno||','||v_dept.loc||','||v_dept.dname);
  6* end;
SQL> /
10,NEW YORK,ACCOUNTING

PL/SQL procedure successfully completed.

SQL>