Hi I am trying to export some fields to out files for data comparison purpose. Though the values get exported, they are getting padded with extra spaces to the full size of filed. (e.g. for datatype Varchar2(200), the field is getting filled with additional spaces in addition to the data values.). There by the comparision by unix diff method fails the result (eventhough the values match).
The syntax i have followed is: .export report file=$ROOT/Tgt_data.out SELECT trim(field1) (title ' '), trim(field2) (title ' ') ---------- ---------- FROM WHERE .export reset
Example output: Suppose field1 is Varchar(100) its a name field and value stored is 'satya' =>output appears 'satya'