SQL problem

Nengbing Tao

Suppose I have a table X with columns A, B, C, D, (all have data type VARCHAR2(2)) and data rows like ('a1','b1','c1','d1') and ('a2','b2','c2','d2').
I need to create a report with 2 columns like ('|' isused to indicate column separation):

A B | C D
a1  | c1
b1  | d1
a2  | c2
b2  | d2

I would like to have it done with SQL, is it possible?

hrg7389

unload to f1.txt select a,c from x;
unload to f2.txt select b,d from x;
cat f2.txt >;>; f1.txt