13 of 13 - Oracle APEX 5 - Views with one-sided and full outer joins; make pages public

This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create a view that uses one-sided outer joins to show ALL records from one table and any related records from other tables. We use a full outer join to to show ALL records in both tables. (By default, when you join 2 tables you only see records that are related between the two tables.) Next, we modify the main navigation menu. Last, we make some pages public so no login is required to view these pages. SQL scripts for this series are available to download at: http://web.nmsu.edu/~jkreie/oracle/DatabaseTopics.html or by request at http://db.kreie.net