select t.TaskID,t.UserID,t.SubmitTime,t.Status,
Sum(a.FileSize) as AllSize,
Sum(1) as totalCount,
Sum(decode(r.Status,'S',1,0)) as SuccessCount,
Sum(decode(r.Status,'W',1,0)) as WaitCount ,
Sum(decode(r.Status,'X',1,0)) as FailCount
from ResourceTable a,Export_Task t
where t.TaskID=r.TaskID(+)
r.ResourceID=a.ResourceID
Group by t.TaskID
Order by t.SubmitTime asc;
Sum(a.FileSize) as AllSize,
Sum(1) as totalCount,
Sum(decode(r.Status,'S',1,0)) as SuccessCount,
Sum(decode(r.Status,'W',1,0)) as WaitCount ,
Sum(decode(r.Status,'X',1,0)) as FailCount
from ResourceTable a,Export_Task t
where t.TaskID=r.TaskID(+)
r.ResourceID=a.ResourceID
Group by t.TaskID
Order by t.SubmitTime asc;
Sum(a.FileSize) as AllSize,
Sum(1) as totalCount,
Sum(decode(r.Status,'S',1,0)) as SuccessCount,
Sum(decode(r.Status,'W',1,0)) as WaitCount ,
Sum(decode(r.Status,'X',1,0)) as FailCount
from ResourceTable a,Export_Task t
where t.TaskID=r.TaskID(+)
and
r.ResourceID=a.ResourceID
Group by t.TaskID
Order by t.SubmitTime asc;
Sum(a.FileSize) as AllSize,
Sum(1) as totalCount,
Sum(decode(r.Status,'S',1,0)) as SuccessCount,
Sum(decode(r.Status,'W',1,0)) as WaitCount ,
Sum(decode(r.Status,'X',1,0)) as FailCount
from ResourceTable a,Export_Task t
where t.TaskID=r.TaskID(+)
r.ResourceID=a.ResourceID
Group by t.TaskID ,t.TaskID,t.UserID,t.SubmitTime,t.Status
Order by t.SubmitTime asc;
t.TaskID,
t.UserID,
t.SubmitTime,
t.Status,
Sum(a.FileSize) AllSize,
Sum(1) totalCount,
Sum(decode(r.Status,'S',1,0)) SuccessCount,
Sum(decode(r.Status,'W',1,0)) WaitCount ,
Sum(decode(r.Status,'X',1,0)) FailCount
from
ResourceTable a,
Export_Task t
where
t.TaskID=r.TaskID(+)
and r.ResourceID=a.ResourceID
Group by
t.TaskID,
t.UserID,
t.SubmitTime,
t.Status
Order by
t.SubmitTime asc;