Can We Create Views On External Table In Oracle?

Can We Create Views On External Table In Oracle? External tables allow Oracle to query data that is stored outside the database in flat files. No DML can be performed on external tables but they can be used for query, join and sort operations. … Views and synonyms can be created against external tables. Can