If you have an external table defined as a text file with the ORACLE_LOADER driver, you can add data to the text file, and query the text file through the external table. By default, data fields in the text file should be terminated by ','. The tutorial exercise below shows you how add data to the external table defined in the previous exercise:

>edit /oraclexe/test/ext_ggl_links.txt

1101,www.globalguideline,Link #1,88,07-MAY-06

1110,www.globalguideline,Link #2,88,07-MAY-06

>sqlplus /nolog

SQL> connect HR/globalguideline

SQL> SELECT * FROM ext_ggl_links;

  ID URL   NOTES  COUNTS CREATED

--------- ---------------- ----------- -------- ---------

  1101 www.globalguideline Link #1   88 07-MAY-06

  1110 www.globalguideline Link #2   88 07-MAY-06