Re: views & cursors

From: Bert Scalzo <bscalz01_at_7-11.com>
Date: 1998/03/10
Message-ID: <6e4458$mot$1@news.ses.cio.eds.com>#1/1

A cursor is an internal mechanism that is effectively a working set of rows (i.e. rowids) that you wish to process. A view definition is a stored query. For example, create view old_emps as select * from employees where working_flag='N' creates a stored query for later execution. When you issue a select from the view, Oracle actually builds an implicit or internal cursor to fecth the correct rows.

Martin Meadows wrote in message <3504865D.32EB_at_indy.net>...
>Quick newbie question from someone who doesn't have a manual to refer
>to: how are cursors & views different?
>
>Thanks,
>Martin Meadows
Received on Tue Mar 10 1998 - 00:00:00 CST