Re: Oracle NULL vs '' revisited

From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Sat, 25 Aug 2007 08:00:36 +0100
Message-ID: <faok4p$3e3$1$8300dec7@news.demon.co.uk>

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]

-- 
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]


"DA Morgan" <damorgan_at_psoug.org> wrote in message 
news:1187990664.899875_at_bubbleator.drizzle.com...


> Tony Rogerson wrote:

>

>> Then why say this "Natural keys can not change. If it can change IT IS 

>> NOT A KEY it is just a value.".

>>

>> You seem to be under the impression that "Natural keys can not change".

>

> If it CAN change it is NOT a key. That is the definition. Let me give

> you an example.

>

> From the standpoint of my bank and my bank account number ... they

> can never change. I may close an account ... I may open an account.

> But each account is uniquely defined by that account number.

>

> If you need additional help with the concept please ask.

> -- 

> 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 

Received on Sat Aug 25 2007 - 02:00:36 CDT