/* ************************************************ */
/*                                                  */
/* fnctn:   Show the number of orders compleated    */
/*          daily.                                  */
/*                                                  */
/* name:    @c:\oracle\sql\oo_daily.sql             */
/* date:    12-MAY-95                               */
/* creator: Rick Kupcunas (Oracle)                  */
/*                                                  */
/* ************************************************ */

def the_date=&&1
select 'Orders closed in system on &the_date :'||count(*)
from   so_headers
where  s6=10 and
       to_char(s6_date,'DD-MON-YY') = '&the_date';
