Re: VIEWS in Oracle

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Tue, 16 Jan 2007 19:04:22 GMT
Message-Id: <pan.2007.01.16.19.04.21.535067@gmail.com>

On Tue, 16 Jan 2007 17:15:36 +0100, Matthias Matker wrote:

> Can anybody give me a short explanation? Is a VIEW a temporary table?

A view is nothing more than a 'stored select'.

You create a select statement, give it a name, store it under that name in the database and then call it up later by the name rather than by re-entering the entire statement.

There are many reasons for creating views ... and many reasons for NOT creating views. As others have stated, read the Oracle Concepts manual for more definition, detail and rationalle around views.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Tue Jan 16 2007 - 13:04:22 CST