2 Replies Latest reply on Feb 7, 2012 3:03 PM by Richard Martens

    Use of db sequence in a materialized view


      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?


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