Log database logon to a table
SQL>
SQL> CREATE TABLE MyTable (
2 num_col NUMBER,
3 char_col VARCHAR2(60)
4 );
Table created.
SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER LogAllConnects
2 AFTER LOGON ON DATABASE
3 BEGIN
4 INSERT INTO MyTable
5 VALUES (3, 'LogAllConnects fired!');
6 END LogAllConnects;
7 /
Trigger created.
SQL>
SQL> SELECT * FROM MyTable;
no rows selected
SQL> drop table MyTable;
Table dropped.
SQL>
Related examples in the same category