Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: calling sql script from pl/sql
I can not conceive of anything you could do in Oracle that would have improved
performance due to creating tables on the fly. I've no doubt something is out
there but I've never seen it.
Creating tables on the fly is a technique generally learned while using SQL Server or Sybase; products that bump into resource limits that just don't exist in Oracle.
What is accomplished in those environments with "tables on the fly" is accomplished in Oracle with in-line views, PL/SQL tables, arrays, or global temporary tables: None of which are not tables created on the fly.
Daniel Morgan
Radu Lascae wrote:
> With due respect: why?
>
> I'm not a DBA. I can think of several scenario's in BIS applications where
> I'd improve performance of certain repports by creating tables on the fly.
> Some of these reports can't even be created in straight SQL.
>
> Am I bound to outrage the DBA's with whom I'm working?
>
> Regards,
> Radu
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:uc21ba11ld1076_at_corp.supernews.com...
> >
> [...]
> > Creating tables on the fly however must be considered very bad practice.
> >
> > Regards
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
Received on Mon Apr 22 2002 - 09:57:06 CDT