1  select 'EMPNO..........'||empno,
  2	    'ENAME..........'||ename
  3* from emp
SQL> /
EMPNO..........7499
ENAME..........ALLEN

EMPNO..........7521
ENAME..........WARD

EMPNO..........7566
ENAME..........JONES

EMPNO..........7654
ENAME..........MARTIN

SQL> ed
Wrote file afiedt.buf

  1  select 'EMPNO..........'||empno empid,
  2    	    'ENAME..........'||ename ename
  3*    from emp where rownum<3
SQL> /

EMPID                                              ENAME               
-------------------------------------------------- --------------------
EMPNO..........7369                                ENAME..........SMITH
EMPNO..........7499                                ENAME..........ALLEN

SQL> ed
Wrote file afiedt.buf

  1  select 'EMPNO..........'||empno  ||chr(10)||
  2    	    'ENAME..........'||ename output
  3*    from emp --where rownum<3
SQL> /

OUTPUT
---------------------
EMPNO..........7369  
ENAME..........SMITH 
                     
EMPNO..........7499 
ENAME..........ALLEN

SQL> select rpad('EMPNO:',23,'.')||empno  ||chr(10)||
  2         rpad('ENAME:',23,'.')||ename output
  3  from emp where rownum<3;

OUTPUT 
----------------------------
EMPNO:.................7369
ENAME:.................SMITH
                            
EMPNO:.................7499 
ENAME:.................ALLEN

SQL> SET HEAD OFF
SQL> /

EMPNO..........7369
ENAME..........It`smeved

EMPNO..........7499
ENAME..........Blackswan

EMPNO..........7521
ENAME..........littleFoot

SQL> select empno, ename from emp;
empno								ename
12345								john Blake
65432								Michael George

SQL>@vertical_output
Enter Table Name: emp
EMPNO:............12345
ENAME:............John Blake

EMPNO:............65432
ENAME:............Michael George

SQL> exec pv('select * from FNCL_AST');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

create or replace procedure print_table( p_query in varchar2 )
AUTHID CURRENT_USER
is
    l_theCursor     integer default dbms_sql.open_cursor;
    l_columnValue   varchar2(4000);
    l_status        integer;
    l_descTbl       dbms_sql.desc_tab;
    l_colCnt        number;
begin
    execute immediate
    'alter session set 
        nls_date_format=''dd-mon-yyyy hh24:mi:ss'' ';

    dbms_sql.parse(  l_theCursor,  p_query, dbms_sql.native );
    dbms_sql.describe_columns
    ( l_theCursor, l_colCnt, l_descTbl );

    for i in 1 .. l_colCnt loop
        dbms_sql.define_column
        (l_theCursor, i, l_columnValue, 4000);
    end loop;

    l_status := dbms_sql.execute(l_theCursor);

    while ( dbms_sql.fetch_rows(l_theCursor) > 0 ) loop
        for i in 1 .. l_colCnt loop
            dbms_sql.column_value
            ( l_theCursor, i, l_columnValue );
            dbms_output.put_line
            ( rpad( l_descTbl(i).col_name, 30 )
              || ': ' || 
              l_columnValue );
        end loop;
        dbms_output.put_line( '-----------------' );
    end loop;
    execute immediate
        'alter session set nls_date_format=''dd-MON-rr'' ';
exception
    when others then
      execute immediate
          'alter session set nls_date_format=''dd-MON-rr'' ';
      raise;
end;
/

SQL> exec print_table('SELECT * FROM EMP where rownum <3');
EMPNO			      : 7499
ENAME			      : ALLEN
JOB			      : SALESMAN
MGR			      : 7698
HIREDATE		      : 20-feb-1981 00:00:00
SAL			      : 1600
COMM			      : 300
DEPTNO			      : 30
INSERT_DATE		      : 01-jun-2010 21:36:29
-----------------
EMPNO			      : 7521
ENAME			      : WARD
JOB			      : SALESMAN
MGR			      : 7698
HIREDATE		      : 22-feb-1981 00:00:00
SAL			      : 1250
COMM			      : 500
DEPTNO			      : 30
INSERT_DATE		      : 01-jun-2010 21:36:29
-----------------

PL/SQL procedure successfully completed.

SQL> 

SQL> exec print_table('select * from im2.emp where rownum <3');
EMPNO                   			: 100775146
ENAME               					: John Blake
HIRE_DT                       : 01-jun-2009 16:36:10
SALARY                   			: 90000
-----------------
EMPNO                  			  : 100800985
ENAME               					: Michael George
HIRE_DT                       : 30-may-2009 18:52:52
SALARY                   			: 80000
-----------------

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

SQL> SELECT OBJECT_TYPE, OWNER from DBA_OBJECTS WHERE OBJECT_NAME = 'PV';

OBJECT_TYPE         OWNER
------------------- ------------------------------
PROCEDURE           B8345B
SYNONYM             Im2_TOOL
SYNONYM             Im2
SYNONYM             B22222              ----- thats me

Elapsed: 00:00:00.06