Coba script ini deh di when-timer-expired :
DECLARE
hour_timer TIMER;
one_minute NUMBER(7):=1000;
tg varchar2(20);
BEGIN
select to_char(sysdate + 1/1440,'hh24:mi:ss')
into :jam from dual;
tg := to_char(sysdate,'dd-mm-yyyy');
:jam_in := to_date(tg||' '||:jam,'dd-mm-yyyy hh24:mi:ss');
END;
Semoga berguna
Ermiriwani Pangloli
Information System Department
PT. Indonesia Toray Synthetics
Tel : +62 (21) 520 0289
Fax : +62 (21) 520 2041
http://ermiriwani.blogspot.com
"Clara Devi" <[EMAIL PROTECTED]>
17/02/2005 04:29 PM
Please respond to indo-oracle
To: <[email protected]>
cc:
Subject: Re: [indo-oracle] Re: setting time
Saya juga sudah set di when-timer-expired selama 60 menit tp hanya untuk
menampilkan alert kalau waktunya sudah 60 menit. Tp untuk menampilkan di
form setting waktu nya seperti stopwatch atau countdown boleh tau ga
caranya
gimana?
Sorry ya saya masih pemula di oracle jd lagi belajar
thanks ya tuk masukannya
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, February 17, 2005 3:22 PM
Subject: Re: [indo-oracle] Re: setting time
>
> Kami kebetulan juga develop form seperti yang Anda maksud.
> Untuk format jamnya, kami pake type data datetime dengan format mask
> HH24:MM:SS
>
> Untuk membuat tampilan seperti stopwatch atau countdown, gunakan
trigger
> when-timer-expired
>
> Thanks
>
>
>
>
>
> "Clara Devi" <[EMAIL PROTECTED]>
> 17/02/2005 03:09 PM
> Please respond to indo-oracle
>
>
> To: <[email protected]>
> cc:
> Subject: [indo-oracle] Re: setting time
>
>
>
> Untuk menampilkan format jam saya sudah dapat yaitu type data jangan
> date tp Character
> hanya permasalahan sekarang ada yang tau ga untuk membuat tampilan
di
> form seperti stopwatch atau countdown
> yang sudah di setting selama 60 menit
>
> thanks
>
>
>
> ----- Original Message -----
> From: Clara Devi
> To: [email protected]
> Sent: Thursday, February 17, 2005 2:08 PM
> Subject: setting time
>
>
> Dear all,
>
> Saya langsung aja mo nanya ni kira2 ada yang mengerti tampilan di
form
> oracle untuk menampilin waktu
> misanya 01:00:00, saya harus setting dengan type data apa dan di
> format mask apa seperti ini bisa HH24:MI:SS ?
>
> Saya pernah coba dgn tipe data Date dan format mask DD-MM-YYYY
> HH24:MI:SS yang munculnya hanya 01-01-2005 00:00:00.
> Menggunakan oracle developer form 6.0
>
> mohon bantuannya, thanks
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
