Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: order by in VIEWs
On Thu, 19 Aug 1999 15:28:48 GMT, Nandakumar <nanban_at_my-deja.com>
wrote:
>How is Oracle 8i different from Enterprise Edition?
Oracle 8i is in fact a marketing name for Oracle8.1 (current release 8.1.5). It comes in at least three different version (the following might not be the exact naming that are used this days, the naming changes from release to release):
-Enterprise edition - the complete edition, with each and every option
available
- Workgroup (or simply "Server") edition - basically same as the
enterprise, except some of the options are not available and only
servers up to 4 CPUs are supported.
- Personal edition - single user edition, but with very similar
features as workgroup.
And you can add "Lite" edition to that - this is the lowest part of the palette, single user with no PL/SQL and other stuff.
>I would like to know about materialized views.
>like how this is different from other oracle views.
Materialized views, available only in Oracle8i Enterprise, are not views in the true meaning of the word, because they physically contain data, as opposed to normal views which are simply stored SQL queries. MVs are more like snapshots. They are used in data warehouses for automated maintaining of aggregated data.
>btw, what are these inline and explicit views?.
Normal view (I used the word explicit, maybe it is not the right one) is the one that is created with CREATE VIEW command. It is stored in the data dictionary.
An inline view is the SELECT used in the FROM clause of the outer select, so it is not stored anywhere in the database. An example:
SELECT * FROM (SELECT e.ename, d.dname FROM emp e, dept d
WHERE e.deptno = d.deptno);
>If you could provide with some documents, study materials, that
>would be greatly appreciated.
Ordinary Oracle documentation should be sufficient.
>Thanks
>Nanda
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)