Re: Oracle NULL vs '' revisited

Great, I'll send stuff over thru the next couple of weeks.

Start with these two...

"Translate character string using character set"

We use CAST which I believe is ANSI standard as well; Oracle uses TREAT which I believe isn't ANSI standard.

CAST( <expression> AS <type> )

"Table Level Triggers"
"statement level"

I don't believe Oracle has proper statement level triggers, by that I mean the new and old values for ALL rows modified by the statement are available.

In SQL Server we have the inserted and deleted tables; I don't believe there is Oracle equiv that gives the complete set of rows as a table that are being inserted/deleted/updated.

Row level triggers, we just use a cursor against the "inserted" and/or "deleted" system materialised views.

INSTEAD OF is a before trigger in SQL Server.

I'll send the rest via email once you have updated the current document to reflect the above.

Many thanks,
Tony.

-- 
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:1187557044.657456_at_bubbleator.drizzle.com...


> Tony Rogerson wrote:

>>>> Seems reasonable. Perhaps you could teach that trick to Microsoft.

>>

>> I came across this biased bull sh1t -> 

>> http://www.psoug.org/reference/sqlserver.html which I'm starting to 

>> readdress your obvious total lack of any experience or knowledge of SQL 

>> Server.

>>

>> Anyway, that aside, with have the configuration manager for one that 

>> enables step by step enabling of various features of the product via a 

>> GUI or through the command line via T-SQL.

>>

>> I know I'm talking to a wall while saying that but your answer may prove 

>> amusing.

>>

>> Tony.

>

> Any time you find something you don't agree with send me a correction

> and a link where it can be verified. Glad to fix it.

> -- 

> 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