je normalni ?

[Jan Serak]

Milan Sorm wrote:
> 
> je normalni, kdyz muzu udelat select * from nejake_view, ale nemuzu udelat
> select count(*) from nejake_view a musim psat select count(*) from (select *
> from nejake_view) ? muze to byt tim view ?

A proc to nemuzete udelat?

SQL> create view kuk as (select * from dual union select * from dual);

View created.

SQL> select * from kuk;

D
-
X

SQL> select count(*) from kuk;

  COUNT(*)
----------
         1

Funguje jak v Oracle 7.3.4 tak v 8i.

						Jan Serak