I need to write to a table. [message #369810] |
Tue, 17 October 2000 11:48 |
Luis Gabriel
Messages: 11 Registered: October 2000
|
Junior Member |
|
|
Hi,
I need to write to a table when somebody connects to oracle (I have oracle 7.3.2) and erase this record when
the user disconnects from oracle.
Can somebody help me please?'
Tanks.
|
|
|
|
Re: I need to write to a table. [message #369817 is a reply to message #369810] |
Wed, 18 October 2000 02:48 |
Venkatramanan
Messages: 10 Registered: October 2000
|
Junior Member |
|
|
Hi Chris,
U can write a trigger like this :
CREATE OR REPLACE TRIGGER <name> AFTER LOGON
ON DATABASE
BEGIN
<insert into table statement>
END;
CREATE OR REPLACE TRIGGER <name> BEFORE LOGOFF
ON DATABASE
BEGIN
<delete from table statement>
END;
Venkatramanan.
|
|
|