hi all,

iam stuckup in a particular query whose result would be a kind of report.my table contains below fileds, now i want a report on area_name and tvcm_version criteria i.e if suppose i want to get the result on area_name & tvcm_version for eg i want to see
that on area_name=abc and tvcm_version=p97 how much time was spend on each logical_day on testing,research,review & document.

LOGICAL_DAY AREA_NAME ACT_NAME TVCM_VERSION TVCM_HRS
01-Sep-03 abc testing p97 2
01-Sep-03 xyz research p99 2
02-Sep-03 abc testing p97 4
02-Sep-03 abc research p97 3
02-Sep-03 abc review p97 2
03-Sep-03 abc document p97 4

Oracle LazyDBA home page