Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Article about supposed "murky" future for Oracle
rkusenet wrote:
> "Thomas Kyte" <thomas.kyte_at_oracle.com> wrote
>
>
>>Well, I didn't prove that really -- the point I made on page 35 was >>that
No. As stated above ... ran this at a large national bank. And believe what we found.
> Instead of SCROLL CURSOR, a TEMP TABLE can also be created for same.
And what happens during the time the temp table is being loaded? Same thing that happens in SQL Server. Surely you are not advocating a full table lock for as long as it takes to load a temp table.
> I am sure same technique will work just fine in SQLServer.
>
> Bottomline: this was never an issue in any enterprise RDBMS.
Except Oracle.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Mar 30 2004 - 15:15:42 CST