Oracle database tables are accessed using structured query language (SQL). The user views the SQL results on a screen or spools it to a file for later use. Several SQL commands are used in sequential order to add a delimiter to separate column values in the output file. Using a delimiter makes importing the file into Excel, Access or other applications an easier task because it eliminates the need to define the specific length of each field. set colsep “&TAB” select * from test_table Results without changing the delimiter are displayed in the following manner: VALUE 1 | VALUE 2 | VALUE 3 Results after changing the column separator to a tab delimiter are displayed in the following manner: VALUE 1 VALUE 2 VALUE 3 Writer Bio
