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> select * from myTable
2 where rownum <= 5;
SQL> drop table myTable;