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