In order to access a MV, user needs to replace the base table name with the MV name in the query
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- If you need to change the display name for the fields of a table you need to change it in the .pmd file.
- If base table does not exists, can we create a view?
- In a join condition it is mandatory to specify the table name along with the column name
- In a join condition it is mandatory to specify the table name along with the Column name.
- In a join condition it is mandatory to specify the table name along with the Column name.
- In a join condition it is mandatory to specify the table name along with the Column name.
- In a join condition it is mandatory to specify the table name along with the Column name.
- If Product is a table name than a) RENAME product to PRO; b) ALTER TABLE product RENAME TO pro;