Re: Please assist with database event trigger

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 5 Nov 2000 13:10:20 -0000
Message-ID: <973426124.21895.1.nnrp-03.9e984b29@news.demon.co.uk>

BTW -
If you really want this trigger to affect ONLY the aradmin schema, you can do:

create or replace trigger aradmin.logon_trigger after logon on ARADMIN.SCHEMA
begin

execute immediate
'alter session set nls_date_format=''DD-MON-YYYY'''; end;

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison Wesley Longman
Book bound date now 1st Dec 2000

Received on Sun Nov 05 2000 - 07:10:20 CST