SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel cells alignment when spooling data from sql through Unix shell script

887208Sep 27 2011 — edited Sep 27 2011

Hi,

I have a table which is having varchar columns.

I need to spool that data into xls format through unix shell script.

Whenever, I do this, I get excel with columns in the below gien format.

0N40T610
0N60T559
1040
140370
5N40T258
6N60T388
7080
880395
8N80T507
BMHBA
EBINZ
ENAGF
FMAMXX
GDMIVX
IEUE44
NDBLK1
NDHLK1
NMHRPG
NN60T20757

You can observe all the cells containing only numerals get right aligned automatically according to default excel format.

I need to make this uniform to have a better look in my exce.

i.e., all the cells shoudl be left aligned.

Please suggest me a way I can make it possible through sql that I have used in my shell script.

Edited by: user9315951 on Sep 27, 2011 12:22 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2011

Added on Sep 27 2011

#database, #excel, #sql

5 comments

2,810 views