Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9831
  • 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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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