7: m varchar2(10);
8: s varchar2(10);
9: temp number;
10: begin
11: select to_char(lpad(trunc(sec/3600),2,'0')) into h from dual;
12: select mod(sec, 3600) into temp from dual;
13: select to_char(lpad(trunc(temp/60),2,'0')) into m from dual;
14: select mod(temp, 60) into s from dual;
15: return h || ':' || m ||':' || s;
8: s varchar2(10);
9: temp number;
10: begin
11: select to_char(lpad(trunc(sec/3600),2,'0')) into h from dual;
12: select mod(sec, 3600) into temp from dual;
13: select to_char(lpad(trunc(temp/60),2,'0')) into m from dual;
14: select mod(temp, 60) into s from dual;
15: return h || ':' || m ||':' || s;
16: end getRealTime;
9: temp number;
10: begin
11: select to_char(lpad(trunc(sec/3600),2,'0')) into h from dual;
12: select mod(sec, 3600) into temp from dual;
13: select to_char(lpad(trunc(temp/60),2,'0')) into m from dual;
14: select mod(temp, 60) into s from dual;
15: return h || ':' || m ||':' || s;
16: end getRealTime;
17:
10: begin
11: select to_char(lpad(trunc(sec/3600),2,'0')) into h from dual;
12: select mod(sec, 3600) into temp from dual;
13: select to_char(lpad(trunc(temp/60),2,'0')) into m from dual;
14: select mod(temp, 60) into s from dual;
15: return h || ':' || m ||':' || s;
16: end getRealTime;
17:
18: FUNCTION getEnabled (code in VARCHAR2,