declare
cursor cs is select orders.order_num,orders.cust,orders.order_date,customers.company 
            from orders inner join customers
             ON  orders.order_date > TO_DATE('01-JAN-08','DD-MM-YY') AND orders.order_date <TO_DATE('01-JAN-99','DD-MM-YY');
buf orders%rowtype;
buf1 customers%rowtype;
begin
    open cs;
        fetch cs into buf.order_num,buf.cust,buf.order_date;
        while  cs%found
        loop
        dbms_output.put_line(cs%rowcount || '  ' || buf.order_num || '   ' || buf.cust || '  '
        || buf.order_date);
        fetch cs into buf.order_num,buf.cust,buf.order_date;
        end loop;
            dbms_output.put_line(cs%rowcount);
    close cs;   
end;

 not in (select order_date from orders where orders.order_date > TO_DATE('01-JAN-08','DD-MM-YY') AND orders.order_date <TO_DATE('01-JAN-99','DD-MM-YY'));