SQL> set pagesize 0
SQL> column eol newline
SQL>
SQL> select 'Table_Name    : ' || TABLE_NAME eol,
  2         'Num_Rows      : ' || NUM_ROWS eol,
  3         'Last_Analyzed : ' || LAST_ANALYZED eol
  4  from USER_TABLES
  5  where rownum < 5;
Table_Name    : ABC
Num_Rows      : 0
Last_Analyzed : 08-MAY-09

Table_Name    : TABLE_A
Num_Rows      : 2220
Last_Analyzed : 19-MAY-09

Table_Name    : TABLE_B
Num_Rows      : 12585
Last_Analyzed : 08-MAY-09

Table_Name    : TABLE_C
Num_Rows      : 3795
Last_Analyzed : 19-MAY-09

SELECT   DISTINCT To_char(SYSDATE,'MM/DD/YYYY hh24:mi:ss') "TODAY",
                  'The access to the following responsibility has been changed for user:'
                  ||resp_chng.employee_name eol,
                  'Responsibility:'
                  ||resp_chng.responsibility_name eol,
                  'Change Date:'
                  ||resp_chng.resp_last_update_date eol,
                  'Assign.Start Date:'
                  ||resp_chng.resp_start_date eol,
                  'Assign.End Date:'
                  ||resp_chng.resp_end_date eol,
                  'User Start Date:'
                  ||resp_chng.resp_creation_date eol,
                  'User End Date:'
                  ||resp_chng.resp_last_update_date eol
FROM     xx.xx_rs_100_613_emp_resp_chng resp_chng,
         fnd_user fu_cr,
         fnd_user fu_upd
WHERE    fu_cr.user_id = resp_chng.resp_created_by
         AND fu_upd.user_id = resp_chng.resp_last_updated_by
-- AND TRUNC(resp_chng.resp_last_update_date) BETWEEN TO_DATE('&&1','YYYY/MM/DD HH24:MI:SS') 
-- AND TO_DATE('&&2','YYYY/MM/DD HH24:MI:SS')
ORDER BY --TRUNC('User End Date:'||resp_chng.resp_last_update_date),
 'The access to the following responsibility has been changed for user:'
         ||resp_chng.employee_name;