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.