troubleshooting Question

Find missed day & store

Avatar of NiceMan331
NiceMan331 asked on
Oracle Database
42 Comments2 Solutions198 ViewsLast Modified:
i previously asked this question
https://www.experts-exchange.com/Database/Oracle/Q_28229246.html

it was works well to get the missed days for data of one store
now if i want to add store number to the result , like this


declare
cursor c_stores is 
select a.str_no
 from cr_store a
where a.opdate > '28-dec-13';

BEGIN
FOR i in c_stores
   LOOP
  
SELECT i,tc.DATE_TIME_START
FROM calendar_table tc
where tc.date_time_start between '01-jan-14' and sysdate
and tc.date_time_start
not IN
(select ds.dob from 
cr_gnditem ds
where ds.unit = i 
and ds.dob between '01-jan-14' and sysdate
group by ds.dob)
order by tc.DATE_TIME_START;
end loop;
end;

but it sent me error message that data wrong of type
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 42 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 42 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros