Code:
CREATE OR REPLACE VIEW MMSSENDAVGUPLOADTIME_GN
AS
sp_strip_mean_value_type.get_val(MMSSENDAVGUPLOADTIME) MMSSENDAVGUPLOADTIME_val
sp_strip_mean_value_type.get_val(MMSSENDAVGUPLOADTIME) MMSSENDAVGUPLOADTIME_counter
select IMSI_ID,MCC_ID,MNC_ID,TIME_ID,COUNTER,ERRORCOUNT,
PDPCREATEATTEMPT,PDPCREATEFAILNETWORK,PDPCREATESUCCESS,
USERAGENT,HTTPGETATTEMPT,HTTPGETAVGTHROUGHPUT,
HTTPGETBYTES,HTTPGETSUCCESS,HTTPPOSTATTEMPT,
HTTPPOSTAVGTHROUGHPUT,HTTPPOSTBYTES,HTTPPOSTSUCCESS,
WAPGETATTEMPT,WAPGETAVGTHROUGHPUT,WAPGETBYTES,
WAPGETSUCCESS,WAPPOSTATTEMPT,WAPPOSTAVGTHROUGHPUT,
WAPPOSTBYTES,WAPPOSTSUCCESS,MMSRETRIEVEATTEMPT,
MMSRETRIEVEAVGDOWNLOADTIME,MMSRETRIEVEAVGTTFB,
MMSRETRIEVEAVGTHROUGHPUT,MMSRETRIEVEBYTES,
MMSRETRIEVESUCCESS,MMSSENDATTEMPT,MMSSENDAVGTTFB,
MMSSENDAVGTHROUGHPUT,MMSSENDAVGUPLOADTIME,MMSSENDBYTES,
MMSSENDSUCCESS,URL1ACCESSATTEMPT,URL1ACCESSSUCCESS,
URL1AVGDOWNLOADRATE,URL1AVGDOWNLOADTIME,URL1AVGTTFB,
URL2ACCESSATTEMPT,URL2ACCESSSUCCESS,URL2AVGDOWNLOADRATE,
URL2AVGDOWNLOADTIME,URL2AVGTTFB,URL3ACCESSATTEMPT,
URL3ACCESSSUCCESS,URL3AVGDOWNLOADRATE,
URL3AVGDOWNLOADTIME,URL3AVGTTFB,URL4ACCESSATTEMPT,
URL4ACCESSSUCCESS,URL4AVGDOWNLOADRATE,
URL4AVGDOWNLOADTIME,URL4AVGTTFB,URL5ACCESSATTEMPT,
URL5ACCESSSUCCESS,URL5AVGDOWNLOADRATE,URL5AVGDOWNLOADTIME,
URL5AVGTTFB,URL6ACCESSATTEMPT,URL6ACCESSSUCCESS,
URL6AVGDOWNLOADRATE,URL6AVGDOWNLOADTIME,URL6AVGTTFB,
URL7ACCESSATTEMPT,URL7ACCESSSUCCESS,URL7AVGDOWNLOADRATE,
URL7AVGDOWNLOADTIME,URL7AVGTTFB,URL8ACCESSATTEMPT,
URL8ACCESSSUCCESS,URL8AVGDOWNLOADRATE,URL8AVGDOWNLOADTIME,
URL8AVGTTFB,PDPCREATEFAIL,PDPCREATEFAILUSER,PDPCREATETIMEOUT,A
VGCLIENTSETUPTIME,AVGDOWNLOADTIME,AVGENDTOENDTIME,
AVGSERVERSETUPTIME,AVGTTFB,AVGUPLOADTIME,GETATTEMPT,
GETAVGTHROUGHPUT,GETSUCCESS,POSTATTEMPT,
POSTAVGTHROUGHPUT,POSTSUCCESS,HTTPGETTIMEOUT,
HTTPPOSTTIMEOUT,WAPGETABORT,WAPPOSTABORT,
MMSRETRIEVEAVGENDTOENDTIME,MMSSENDAVGENDTOENDTIME,
URL1AVGENDTOENDTIME,URL2AVGENDTOENDTIME,
URL3AVGENDTOENDTIME,URL4AVGENDTOENDTIME,
URL5AVGENDTOENDTIME,URL6AVGENDTOENDTIME,
URL7AVGENDTOENDTIME,URL8AVGENDTOENDTIME,PDPUPDATEATTEMPT,
PDPUPDATEFAIL,PDPUPDATEFAILNETWORK,PDPUPDATEFAILUSER,
PDPUPDATESUCCESS,PDPUPDATETIMEOUT,PDPDELETEATTEMPT,
PDPDELETEFAIL,PDPDELETEFAILNETWORK,PDPDELETEFAILUSER,
PDPDELETESUCCESS,PDPDELETETIMEOUT from gn_imsi_15_user@dblink where time_id=(select max(time_id) from gn_imsi_15_user@dblink) and imsi_id in (select imsi_id from gn_imsi_15_user);
