Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9938
  • Last Modified:

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

-----------
0
Bajwa
Asked:
Bajwa
  • 2
  • 2
1 Solution
 
rajeXshCommented:
Justify only aligns the heading, not the data
0
 
BajwaAuthor Commented:
How do you justify the data then?
0
 
rajeXshCommented:
You'll have to convert all the data to character and use the LPAD or RPAD functions
0
 
BajwaAuthor Commented:
Thanks......
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now