Help - Search - Members - Calendar
Full Version: Differences
Oracle DBA Forums > Oracle > Oracle Forum
Oracle Learner
Hi All smile.gif ,
I want to know the differences between functional view and composite view.
Can anybody answer to my question?

With Regards
Oracle Learner
SteveC
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).
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.