Re: VIEWS in Oracle

From: gazzag <gareth_at_jamms.org>
Date: 16 Jan 2007 08:19:11 -0800
Message-ID: <1168964348.305940.157880@l53g2000cwa.googlegroups.com>

Matthias Matker wrote:
> Hello together,
>
> we have to do some SQL-terms in oracle using "sqlplus" at our university.
>
> Something like SELECT with JOINS, and later on, more complex issues.
>
> We are allowed to use VIEWS, but we have to clean them up after the work
> is done.
>
> But I really don't know, what "VIEWS" are and which purpose they are
> used for.
>
> Can anybody give me a short explanation? Is a VIEW a temporary table?
>
> Thanks
>
> Matze

Peruse the "Concepts" guide on Oracle's website. Views are explained here:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref787

HTH -g Received on Tue Jan 16 2007 - 10:19:11 CST