Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / View

 

Create a view to link two table together

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> 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.