Unloading to a Delimited File

You can unload data to a delimited-ASCII text file from a table, as the following example shows:

CREATE EXTERNAL TABLE emp_ext 
SAMEAS employee
USING (
    DATAFILES ("DISK:/work2/mydir/emp.dat") 
    );
INSERT INTO emp_ext SELECT * FROM employee;

Delimited files are ASCII by default.