oracle8.1.6 select count(1) from ($__thisrow(sql_query)) select sm.spam_id, to_char(sm.send_date, 'Mon DD, YYYY HH:MI:SS PM') wait_until, decode (sm.approved_p, 't', 'Approved', 'f', 'Not Approved', 'Error') pretty_approved, approved_p, sm.sql_query, sm.header_subject as title, acs_permission.permission_p(sm.spam_id, :user_id, 'admin') as admin_p from spam_messages_all sm where sent_p = 'f' and acs_permission.permission_p(sm.spam_id, :user_id, 'write') = 't' order by sm.send_date select sm.spam_id, sm.header_subject as title, sm.send_date from spam_messages_all sm where sent_p = 't' and acs_permission.permission_p(sm.spam_id, :user_id, 'read') = 't' order by sm.send_date