Home » SQL & PL/SQL » SQL & PL/SQL » About database login system trigger
About database login system trigger [message #36661] Mon, 10 December 2001 21:21 Go to next message
Yuvraj Thapa
Messages: 28
Registered: May 2001
Junior Member
Dear Oracle Experts,
In my app. i've created database login trigger which keep all the login information of user in a seperate table. but I want to keep information about log out events of user. please help me to write system triger on log out. And also how to create table in partition and what is advantage using partition.
Please reply soon,
Thanking You,
Yuvraj

----------------------------------------------------------------------
Re: About database login system trigger [message #36672 is a reply to message #36661] Tue, 11 December 2001 04:44 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
create or replace trigger trig_log_info
before logoff on database
begin
insert into s100 values('logged out');
end;

----------------------------------------------------------------------
Re: About database login system trigger [message #36677 is a reply to message #36661] Tue, 11 December 2001 18:13 Go to previous message
Yuvraj Thapa
Messages: 28
Registered: May 2001
Junior Member
Thank U very much.
It's work.
With Best Regards & Happy New Year.
Yuvraj

----------------------------------------------------------------------
Previous Topic: Reference problems
Next Topic: Sending mail from PL/SQL procudure
Goto Forum:
  


Current Time: Thu Oct 29 21:08:29 CDT 2020