Re: Help - SQL*Plus report format

From: <elric_dm_at_netvision.net.il>
Date: 1996/03/13
Message-ID: <NEWTNews.826782424.18477.elric_dm_at_dialup.netvision.net.il>#1/1


In Article<4i4tnp$3q4_at_masala.cc.uh.edu>, <ymeng_at_Bayou.UH.EDU> write:
> Path:

news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!gatech!swr inde!news.uh.edu!ymeng
> From: ymeng_at_Bayou.UH.EDU (Jerry Xia)
> Newsgroups: comp.databases.oracle
> Subject: Help - SQL*Plus report format
> Date: 12 Mar 1996 22:27:05 GMT
> Organization: University of Houston
> Lines: 8
> Message-ID: <4i4tnp$3q4_at_masala.cc.uh.edu>
> NNTP-Posting-Host: bayou.uh.edu
> X-Newsreader: TIN [version 1.2 PL2]
>
> I am using SQL*Plus to generate a report. There are only two short columns
 on
> my report. I want to place these data in the central part of the paper
> (that is, not start from column 1) and leave equivalent space in both sides.
> Which commands and options I should use ?
>
> Thanks in advance.
>
> Jerry

If your in charecter mod try
select lpad (' ',40 - (length(<col1>) + length(<col2>))) || <col1> || <col2> from <table> Received on Wed Mar 13 1996 - 00:00:00 CET

Original text of this message