Link to home
Start Free TrialLog in
Avatar of Bajwa
BajwaFlag for United States of America

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

-----------
Avatar of rajeXsh
rajeXsh

Justify only aligns the heading, not the data
Avatar of Bajwa

ASKER

How do you justify the data then?
ASKER CERTIFIED SOLUTION
Avatar of rajeXsh
rajeXsh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bajwa

ASKER

Thanks......