Re: Dynamice SQL in Oracle

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 12 May 2005 16:57:15 -0700
Message-ID: <1115941980.272152@yasure>

Maxim Demenko wrote:

> As the table t was created with execute immediate, he didn't have
> another choice ;-)
>
> Best regards
>
> Maxim

Actually he did. Anyone creating a table using EXECUTE IMMEDIATE has a choice.

The choice to not try to kludge SQL Server habits into Oracle and to do their DDL according to "best practices" using global temporary tables.

What is, in effect, being said here is: "If I do something stupid it doesn't work." And on that I will agree.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu May 12 2005 - 18:57:15 CDT