1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| SQL> create table trgtab ( lig number )
2 /
Table crÚÚe.
1 create or replace trigger tal after logon on database
2 begin
3 insert into trgtab values ( to_number(to_char(sysdate,'YYYYMMDDHH24MISS') ) ) ;
4* end;
SQL> /
DÚclencheur crÚÚ.
SQL> select * from trgtab
2 /
aucune ligne sÚlectionnÚe
SQL> insert into trgtab values ( to_number(to_char(sysdate-1,'YYYYMMDDHH24MISS') ) ) ;
1 ligne crÚÚe.
SQL> select * from trgtab
2 /
2,0111E+13
SQL> conn / as sysdba
ConnectÚ.
SQL> select * from trgtab
SQL> col lig for 99999999999999
SQL> /
20110627170022
20110628170046 |
Partager