Join view - Definition - Oracle Views, Sequences, and Synonym

Discussion

• Nirja Shah   -Posted on 30 Sep 15
  - You can also create views that specify more than one base table or view in the FROM clause.
  
  - These are called join views.
  
  - The following statement creates the division1_staff view that joins data from the emp and dept tables:
  
  CREATE VIEW division1_staff AS
  SELECT ename, empno, job, dname
  FROM emp, dept
  WHERE emp.deptno IN (10, 30)
  AND emp.deptno = dept.deptno;
  
  - An updatable join view is a join view where UPDATE, INSERT, and DELETE operations are allowed.

➨ Post your comment / Share knowledge