- external tables are mainly used when we have the data in flat files and we need to import that data into database then we go for external tables.
- Using external tables as server face you can define table using position and access data same as structured table, using dml. Perhaps good use is to load external data without use loader with temporal table in order to make validations. You can access records validate it and load directly.
