Home » RDBMS Server » Server Utilities » SQL*Plus Reports
SQL*Plus Reports [message #68956] Wed, 03 October 2001 10:45 Go to next message
sri
Messages: 154
Registered: February 2000
Senior Member
I would like to find out if I can do this kind of formatting in sql plus reports.

Select col1, col2, col3, col4, col5, col6 from tbl

My report should look like this

header info
----------
col1. col2. col3
col4. col5. col6

I mean I would like to have the colns in two different rows. Please assist me.. thanks in advance.

Sri.

----------------------------------------------------------------------
Re: SQL*Plus Reports [message #68966 is a reply to message #68956] Thu, 04 October 2001 22:16 Go to previous message
Anil
Messages: 80
Registered: September 2001
Member
hi Srinivas,

Use sql*plus commands
1)to restrict each column size
2)to set linesize according to your requirement

Reply me about the results.

Regards,
Anil.

----------------------------------------------------------------------
Previous Topic: Re: OCP Exam Papers
Next Topic: Re: OCP Exam Papers
Goto Forum:
  


Current Time: Fri Apr 19 21:09:55 CDT 2024