Create a view to link two table together : Filter View « View « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. View
  3. Filter View
SQL>
SQL>
SQL> CREATE TABLE employee (
  2  id                             number,
  3  name                           varchar(100),
  4  birth_date                     date,
  5  gender                         varchar2(30) );

Table created.

SQL>
SQL> CREATE TABLE employee_evaluation (
  2  id                             number,
  3  title                          varchar2(100),
  4  written_date                   date );

Table created.

SQL>
SQL>
SQL> CREATE OR REPLACE VIEW employee_employee_evaluation as
  2  SELECT employee.id,
  3         employee.name,
  4         employee_evaluation.title,
  5         employee_evaluation.written_date
  6  FROM   employee,
  7         employee_evaluation
  8  WHERE  employee.id = employee_evaluation.id;

View created.

SQL>
SQL> drop table employee;

Table dropped.

SQL>
SQL> drop table employee_evaluation;

Table dropped.








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