Oracle Learner
Jul 16 2008, 11:22 PM
Hi All

,
I want to know the differences between functional view and composite view.
Can anybody answer to my question?
With Regards
Oracle Learner
SteveC
Jul 17 2008, 01:05 AM
Functional view applies a function in either the select statement or in the where clause (create view x as select tax*1.05 from wherever). Composite view is a view based on views and tables (a view on top of a view, so to speak).