2 Replies Latest reply: Feb 7, 2012 9:03 AM by rima RSS

    Use of db sequence in a materialized view

    846220
      Hi,

      Will it be possible to use a database sequence in a materialized view?

      The materialized view is to return the result set of query that joins multiple tables. One of the columns in the result set - the to-be-created materialized view - is null and requires a sequence.

      Will it be possible to include a db sequence in the query?


      Example:

      create materialized view example_mview
      ...
      as
      select example_sequence.nextval, table1.'*', table2.'*'
      from example_table1 table1, example_table2 table2
      where table1.id=table2.id