Re: Hi all

From: sybrandb <>
Date: Mon, 17 Aug 2009 03:35:38 -0700 (PDT)
Message-ID: <>

On 17 aug, 12:24, pal <> wrote:
> Can any one tell me how to declare a temporary table in a trigger(like
> in SQL Server)?

1 In Oracle you don't NEED temporary tables. Oracle is not SQL-server and Oracle has a different read-consistency model. Due to the read-consistency model -or better: lack thereof- SQLserver requires temporary tables. But then Sqlserver is to Oracle what a T-  is to a Ferrari.
You shouldn't try to turn a Ferrari in a T-Ford. 2 Creating database objects on the fly must be considered pure EVIL due to side effects and lack of control on the database. One of the side effects is DDL is automatically committed 3 Moreover, due to side-effects COMMIT is not allowed in a trigger.

You are recommended to learn Oracle, or to keep driving your T-Ford. At least Oracle is available in different colors, and Sqlserver isn't.

Sybrand Bakker
Senior Oracle DBA
Received on Mon Aug 17 2009 - 05:35:38 CDT

Original text of this message