Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: views & cursors

Re: views & cursors

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: 1998/03/10
Message-ID: <35054170.4DE5@ictgroup.com>#1/1

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
Received on Tue Mar 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US