Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
select area_rep_no, to_char(drive_date,'MON') as Month, DRIVE_DATE, sum(projection) as projection , insert_date, 'New Drive/Projection Added' as reason from blood_drives where insert_date between '04-aug-2014' and '10-aug-2014' and drive_cancelled is null and area_rep_no =6 and drive_date between '01-aug-2014' and '31-dec-2014' group by area_rep_NO,drive_date,insert_date union select b.area_rep_no, to_char(b.drive_date,'MON') as Month, DRIVE_DATE,--to_date(to_char(drive_date,'MON'),'MON') as drive_date, sum(b.projection) as projection, audit_insert_date as insert_date, column_name from blood_drives_audit a,blood_drives b where a.audit_key = b.audit_key and area_rep_no =6 and column_name in ('drive_id' ,'drive_cancelled','projection' ) and audit_insert_date between '04-aug-2014' and '10-aug-2014' group by area_rep_no, DRIVE_DATE,to_char(drive_date,'MON'), audit_insert_date, column_name order by area_rep_no,drive_date
|apply oracle patches on windows error||2||31|
|Salary Amount Format||13||51|
|oracle query help||29||50|
|Error when running a simple alter statement in Aqua studio for Oracle||6||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!