Create an external table
SQL> create table myTable 2 (c1 varchar2(80) ) 3 organization external 4 ( 5 type oracle_loader 6 default directory infile 7 access parameters 8 ( 9 records delimited by newline 10 fields 11 (c1 char(80) ) 12 ) 13 location ('xml.lst') 14 ) 15 / SQL> SQL> SQL> select * from myTable 2 where rownum <= 5; SQL> drop table myTable;