1 Reply Latest reply on Jul 18, 2016 10:16 AM by rareddy

    Materialized view on two tables having one to many relationship

    dineshnasa

      I have a requirement to create a materialized view on two tables having one to many relationship such that one table has column say

       

      Dept has two column

      DeptId and DepartmentNmae

       

      Employee Table has

      EmpId and EmployeeName

       

      Dep. Table has one to many relationship with Employee table

       

      I want to create a view such that

       

      DeptEmployeeView  having columns

       

      Dept Id departName EmployeeNames

       

      EmployeeNames column should contain the comma seperated list of EmployeeName from Employee Table