I am a sqlplus newb. I have a table definition similar to the below:
id VARCHAR2(10)
address VARCHAR(40)
etc...
I would like to be able to spool the contents of the table, where the fields maintain their max varchar widths, and concat together. So for example:
id : 0123456789
address: This is an 40 char address with spaces in it
I'd like to spool the output of the table, and have it look like:
0123456789This is an 40 char address with spaces in it
What I get is :
0123456789 This is an 40 char address with spaces in it
I've played with trimspool, linesize, pagesize, but like in the above example: Why is it putting spaces between fields id and address? This is data loaded from a ctl file, via sqlldr, which used positional notation to load the data. All I want to do is to be able to export the (now filtered) data, back into a text file, looking like it did when it was imported.
Could it be that it right-justifies the output?
Thanks for the assistance. Hope this wasn't too confusing :-)