CREATE OR REPLACE TRIGGER set_user_logoff AFTER STARTUP ON DATABASE BEGIN UPDATE user_logon_table SET logoff='YES'; END; /
cmiiw, bw --- In [email protected], "tundungan_cawas" <tundungan_ca...@...> wrote: > > Teman-teman forum..ak minta bantuan...ni ak ada masalaha ada tugas gimana > kalo database oracle mati gara2 listrik mati...trus otomatis ntar kalo > servere dihidupin data status login user yang tersimpan dalam database jadi > off (otomatis jadi logoff)...ak dah cari2 katanya bisa pake Trigger yang > after startup.. >
