Re: Can a procedure contain only a SELECT statement?
From: Mladen Gogala <no_at_email.here.invalid>
Date: Fri, 19 Mar 2010 15:01:30 +0000 (UTC)
Message-ID: <pan.2010.03.19.15.01.30_at_email.here.invalid>
On Fri, 19 Mar 2010 02:40:47 -0700, John Hurley wrote:
Date: Fri, 19 Mar 2010 15:01:30 +0000 (UTC)
Message-ID: <pan.2010.03.19.15.01.30_at_email.here.invalid>
On Fri, 19 Mar 2010 02:40:47 -0700, John Hurley wrote:
> You rarely and really want to stay away from using temporary tables when
> processing work in Oracle.
Not really. There are databases that support local temporary tables very well, SQL Server, Postgres and DB2 are among them. For those database, using local temporary table is something that comes naturally, a very useful feature. Oracle doesn't support transactional DDL, which is the basis for local temporary tables, but that is a lack in Oracle features, not a basis for conclusion that "temporary tables are for wimps because real programmers(TM) use cursors".
-- http://mgogala.byethost5.comReceived on Fri Mar 19 2010 - 10:01:30 CDT