Bajwa
asked on
sqlplus column format
I want the output to be left justified so I enter
column columnname format a9 justify left
but it does not work... Can you tell me what am I doing wrong? check the session.
---------------------
SQL> column EMPCODE justify left
SQL> select empcode from empschd
2 where rownum < 5
3 /
EMPCOD
------
90296
90296
7616
3324
SQL> column EMPCODE justify right
SQL> /
EMPCOD
------
90296
90296
7616
3324
-----------
column columnname format a9 justify left
but it does not work... Can you tell me what am I doing wrong? check the session.
---------------------
SQL> column EMPCODE justify left
SQL> select empcode from empschd
2 where rownum < 5
3 /
EMPCOD
------
90296
90296
7616
3324
SQL> column EMPCODE justify right
SQL> /
EMPCOD
------
90296
90296
7616
3324
-----------
Justify only aligns the heading, not the data
ASKER
How do you justify the data then?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks......