Formating output and combining queries
SQL> select min(timestamp),count(*) from dba_audit_trail where trunc(timestamp) between sysdate-365 and sysdate;
MIN(TIMES COUNT(*)
--------- ----------
29-OCT-10 93480
SQL> select count(*) from dba_audit_trail where trunc(timestamp) between sysdate-365 and sysdate;
COUNT(*)
----------
93480
SQL> select count(*) from dba_audit_trail where trunc(timestamp) between sysdate-30 and sysdate;
COUNT(*)
----------
10
I need this output
Col1 Col2 Col3 Col4
29-OCT-10 93480 93480 10
Can you please help ?
Thanks