SQL> Select * From Alert_XML;

(Harry Dragstra) By mapping an external table to some text file, you can view the file contents as if it were data in a database table. External tables are available since Oracle 9i Database, and from Oracle 11gR2 Database on, it is even possible to do some inline preprocessing on the file.

Read More - Register for Free Membership