Func Toidentifyhdchannel
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Func Toidentifyhdchannel as PDF for free.
More details
- Words: 99
- Pages: 2
create or replace function func_toidentifyhdchannel(bit_rate float,start_time date,end_time date,thershold float) return number is -/*---------------------------------------------------------------------------------------------------------*/ --/*--created by : venkatesan s --------------------------------------------------------------------*/ --/*--datelastmodified : 02-mar-2008 ---------------------------------------------------------------------*/ --/*--purpose : to derive the hd channel according to the logic ---------------------------------*/ --/*--version : 1.0 -----------------------------------------------------------------------------*/ --/*--sample : select func_toidentifyhdchannel(15 ,sysdate,sysdate+1,30) from dual; ------------*/ -/*---------------------------------------------------------------------------------------------------------*/
v_hd number; --/*--to begin -/*---------------------------------------------------------------------------------------------------------*/ --/*---to check whether the channel is hd and set the boolean is true by bitrate and duration of channel seen-*/ -/*---------------------------------------------------------------------------------------------------------*/ if (bit_rate >= 15 and ((end_time - start_time)*1440) >= thershold) then
v_hd :=1; return v_hd;
else
v_hd := 0; return v_hd;
end if; end; /
v_hd number; --/*--to begin -/*---------------------------------------------------------------------------------------------------------*/ --/*---to check whether the channel is hd and set the boolean is true by bitrate and duration of channel seen-*/ -/*---------------------------------------------------------------------------------------------------------*/ if (bit_rate >= 15 and ((end_time - start_time)*1440) >= thershold) then
v_hd :=1; return v_hd;
else
v_hd := 0; return v_hd;
end if; end; /
Related Documents
Func Toidentifyhdchannel
November 2019 26
Func
June 2020 10
Func Honorarios
April 2020 8
B1mt4-func+eq Trigon+func Racionais
May 2020 9
Advtg.role & Func.
July 2020 7