Filter View « View « Oracle PL/SQL Tutorial

8.8.Filter View
8.8.1.Create a view with condition
8.8.2.Creating a simple filtering view
8.8.3.Creating a view that joins tables
8.8.4.Top 'N' analysis
8.8.5.Query a filtering view
8.8.6.Create a view for employee and its course during
8.8.7.Use view to simplify the query
8.8.8.Create a view to link two table together
8.8.9.Use view to wrap complex select statement