Skip to Main Content

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!

Calculating of Start Time for TV Impressions

kdwolfMar 10 2009 — edited Mar 10 2009
I need a help to calculate the right time of some TV Impressions. I thought of using a Model, but...
Here is the case: we have Promotional Breaks between the TV Programmes, each Break has its own start time and within each Break there is a list of Impressions (f.e. promos ) with their respective sequential number, but no Start Time. I need a help to find out the best way to calculate it, PLEASE!

WITH promo_breaks AS (SELECT 1 AS promo_break_id,
36000 AS promo_break_start_time_in_sec
FROM dual),
impressions AS (SELECT 100 AS impression_id,
1 AS promo_break_id,
60 AS imp_duration_in_sec,
1 AS seq_number
FROM dual
UNION ALL
SELECT 101 AS impression_id,
1 AS promo_break_id,
30 AS imp_duration_in_sec,
2 AS seq_number
FROM dual)
SELECT i.impression_id,
b.promo_break_start_time_in_sec,
i.seq_number, --- I WANT TO HAVE ITS START TIME INSTEAD
i.imp_duration_in_sec
FROM impressions i
JOIN promo_breaks b
ON i.promo_break_id = b.promo_break_id
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2009
Added on Mar 10 2009
7 comments
314 views