Re: Create View

> is it possible create view from another two views.

Yes.

> is it possible by program Oracle DBA studio or in another way ?
> Can you give any examples ?

You create a view from views like you create a view from tables.

SQL> CREATE TABLE tbl1 (id number, text varchar2(10));

Table created.

SQL> CREATE VIEW view1 AS SELECT * FROM tbl1 WHERE id < 100;

View created.

SQL> CREATE VIEW view2 AS SELECT * FROM tbl1 WHERE id >= 100;

View created.

SQL> CREATE VIEW view3 AS
2 SELECT * FROM view1
3 UNION
4 SELECT * FROM view2;

View created.

Regards,

Knut Received on Mon Apr 15 2002 - 10:29:52 CDT