Views in Oracle-8

Hi all!

I need some information concerning view capabilities in Oracle-8. Questions:

1. Is it possible to use method invocations in views? In which clause: select, from, where, group by, order by, etc.?
2. Is it possible to define recursive views (given a relation parents-children, define the view "ancestor")?
3. Is it possible to define views with parameters? If so, which is the method of transmission: call-by-value, call-by-name, other?

If the answer to the first question is positive, I have several other questions:

4. Which language can be used to write methods -

    PL/SQL, SQL3, Java, C++, other?
5. Can the programmer use methods with side effects, i.e. methods

    working with own local variables, methods changing the     database state, etc.?
6. Does the view mechanism support polymorphism (dynamic binding)? 7. Are queries having method invocations optimized? Which methods

    are used (query modification, caching results of method invocations, others)?
8. Are views having method invocations updateable? Are view updating

    rules the same as in Oracle-7?
9. Does the view mechanism support the so-called "check option"?

    Does it work for updates of views having method invocations?

Thank you in advance,
Regards,
Kaz Received on Fri Jul 23 1999 - 04:03:38 CDT