Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Weekly count from query data

chandra_1986Feb 25 2021

HI Experts,

We are using database : - 12.1.0.2.0
below query is used for session count for one day.
select count (unique(session_id)) from user.report_data partition
for (to_date('28Jan2021','ddmonyyyy')) where session_id in (select unique(session_id)
from user.report_data partition for (to_date('28Jan2021','ddmonyyyy'))
where logdata like '%Exposed Outside|Dispatched%'
and RECORD_TYPE ='SESSION_DATA') and low_name = 'Update_Put'
and tep_name = 'finaltype' and logdata like '%WreIn%'

How can we use above query to get 1 week session count data.

Thanks

Comments

Processing

Post Details

Added on Feb 25 2021
#plsql, #sqldeveloper
6 comments
504 views