Shell Programming and Scripting

COUNT(*)                   COUNT(*)
----------                 ---------
0                          120

# count the records in myemptable
$ORACLE_HOME/bin/sqlplus -SILENT /NOLOG << EOF > /tmp/temp_output
connect scott/tiger@orcl
set echo off
set serveroutput on
set feedback off
set timing off
set pagesize 3000
set linesize 100
set trimspool on
set tab off
set heading on

select count(*) from MYEMPTABLE where date_entered = sysdate;

select count(*) from MYEMPTABLE where date_entered = sysdate - 7;
EOF

cat /tmp/temp_output

COUNT(*)                   
    ----------                      
        100    

COUNT(*)          
    ----------                       
         120

Select CSD.CountSD, CSDS.CountSDS
From (select count(*) CountSD from MYEMPTABLE where date_entered = sysdate) CSD,
	(select count(*) CountSDS from MYEMPTABLE where date_entered = sysdate - 7) CSDS;

select sum(case when date_entered = sysdate
                then 1 else 0
           end) count1,
       sum(case when date_entered = sysdate - 7 
                then 1 else 0
           end) count2
   from myemptable;

select sum(case when trunc(date_entered) = trunc(sysdate)
                then 1 else 0
           end) count1,
       sum(case when trunc(date_entered) = trunc(sysdate - 7) 
                then 1 else 0
           end) count2
   from myemptable;