Category Archives: SQL

EXTERNAL TABLES

EXTERNAL TABLES

  • We can use external table feature to access external files as if they are tables inside the database. 
  • When we create an external table, we define its structure and location within oracle.
  • When we query the table, oracle reads the external table and returns the results just as if the data had been stored within the database. Continue reading

Related posts: