Re: Hi all
From: sybrandb <sybrandb_at_gmail.com>
Date: Mon, 17 Aug 2009 03:35:38 -0700 (PDT)
Message-ID: <8d00261b-d188-401a-8c38-3a930a788829_at_f37g2000yqn.googlegroups.com>
On 17 aug, 12:24, pal <jayadevpal..._at_gmail.com> wrote:
> Can any one tell me how to declare a temporary table in a trigger(like
> in SQL Server)?
Date: Mon, 17 Aug 2009 03:35:38 -0700 (PDT)
Message-ID: <8d00261b-d188-401a-8c38-3a930a788829_at_f37g2000yqn.googlegroups.com>
On 17 aug, 12:24, pal <jayadevpal..._at_gmail.com> 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 DBAReceived on Mon Aug 17 2009 - 05:35:38 CDT