FYI for those who care ... Oracle8i will support temp tables.
> -----Original Message-----
> From: Mladen Gogala [SMTP:mgogala_at_yahoo.com]
> Posted At: Friday, February 19, 1999 2:44 PM
> Posted To: comp.databases.oracle.server
> Conversation: Can't PL/SQL do the simple stuff that Transact-SQL can?
> Subject: Re: Can't PL/SQL do the simple stuff that Transact-SQL
> can?
>
> In article <36CD836F.88CA7BF8_at_pca.state.mn.us>,
> Kent Eilers <kent.eilers_at_pca.state.mn.us> wrote:
> > Having worked on SQL-Server's Transact-SQL and then moving to PL/SQL
> I've
> > encountered similar moments of disbelief.
> >
> > PL/SQL is a very powerful language. I love its error-handling
> capabilities
> > and its innate structure-building tendencies. But it has
> limitations. I
> > suspect you will discover (if not already) the severve limitations
> Oracle
> > PL/SQL imposes on temp tables. When you look at the functionality
> for temp
> > tables you will discover you cannot use SQL against these tables!
> This
> > really annoys me. Being forced to loop through embedded cursor
> after
> > embedded cursor and write all the 'FETCH INTO ...' syntax adds
> untold hours
> > to my code creation and debugging efforts. Like you I've learned to
> avoid
> > cursors whenever possible due to perforamance reasons but with
> Oracle you
> > have no choice. The whole purpose of SQL was set operations!
> Instead I'm
> > (finding myself) dealing with each individual record via these
> fetch
> > statements..
> >
> > I've been working with PL/SQL for 4 months now. I currently have a
> > distinctly mixed attitude about it. I've worked with SQL-Server and
> > Informix backends before this. I hope after another four months I
> will
> > discover more 'attractions' then 'turn offs.'
> >
>
Received on Fri Feb 19 1999 - 14:38:30 CST
