Re: Oracle NULL vs '' revisited

Tony Rogerson wrote:
> PS. I'm awaiting your email reply to why this isn't an equiv "system
> trigger" in SQL Server compared to your Oracle LOGON trigger....
>
> Link: http://technet.microsoft.com/en-us/library/ms189799.aspx
>
> CREATE TRIGGER connection_limit_trigger
> ON ALL SERVER WITH EXECUTE AS 'login_test'
> FOR LOGON
> AS
> BEGIN
> IF ORIGINAL_LOGIN()= 'login_test' AND
> (SELECT COUNT(*) FROM sys.dm_exec_sessions
> WHERE is_user_process = 1 AND
> original_login_name = 'login_test') > 3
> ROLLBACK;
> END;
>
> Note - it's not a DDL trigger - no DATA DEFINITION in there; it's a
> LOGON trigger.
>
> What's up DA? in Denial Again? Do you really want to make your SQL -
> ORacle comparison page accurate? [I guess not]

The page has been updated. Thanks.

Now stuff the attitude it is really quite unflattering. When I find errors I make corrections. The attitude is suitable for a teenager not an adult professional.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org