Solved

sqlplus column format

Posted on 2002-07-08
4
9,737 Views
Last Modified: 2012-05-05
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
Comment
Question by:Bajwa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:rajeXsh
ID: 7138423
Justify only aligns the heading, not the data
0
 
LVL 5

Author Comment

by:Bajwa
ID: 7138446
How do you justify the data then?
0
 
LVL 2

Accepted Solution

by:
rajeXsh earned 50 total points
ID: 7138461
You'll have to convert all the data to character and use the LPAD or RPAD functions
0
 
LVL 5

Author Comment

by:Bajwa
ID: 7138487
Thanks......
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question