That query returns one instance of the type for each row. Each instance has attributes for each column. You could then use the code like the sample from the JDBC doc to do what you wanted with the individual pieces. But there is still no way to 'print' it all at once.
-- type to match emp record create or replace type emp_scalar_type as object (EMPNO NUMBER(4) , ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2) ) / -- query that creates an instance of emp_scalar_type for each row SELECT emp_scalar_type( empno, ename, job, mgr, hiredate, sal, comm, deptno ) FROM emp;