Re: views & cursors

From: Martin Meadows <mmeadows_at_indy.net>
Date: 1998/03/10
Message-ID: <3505A201.A6A@indy.net>#1/1

Jerry Gitomer wrote:
>
> Hi Martin,
>
> A cursor is an area in memory used for processing SQL statements in
> PL/SQL, PRO*C, and similar products. It's purpose is to allow
> procedural programs to access data going to/from Oracle tables.
>
> A view is a virtual table (with some limitations a table doesn't have)
> that is usually either a subset of a table or the result of a join of
> two or more tables. Its purpose is to hide the details of the data base
> from the user.
>
> Regards
>
> Jerry
>
> Martin Meadows wrote:
> >
> > Quick newbie question from someone who doesn't have a manual to refer
> > to: how are cursors & views different?
> >
> > Thanks,
> > Martin Meadows
>
> --
> Jerry Gitomer ICT Group
> jgitomer_at_ictgroup.com Langhorne PA
> jgitomer_at_p3.net Opinions are mine not those of ICT Group

Thanks for the information Jerry!

Martin Meadows Received on Tue Mar 10 1998 - 00:00:00 CST