Unable to create material view
When I use any functions over the columns in select statement,
then mv is not creating.
eg: select name,id from schema.emp; // no issue with these
select upper(name),substring(id,1,2) from schema.emp // mv is not creating
Please let me know the solution for this..