OraFAQ Forum: SQL & PL/SQL » what changes are to be made to sqlplus to show all the data on a single lin

Home » SQL & PL/SQL » SQL & PL/SQL » what changes are to be made to sqlplus to show all the data on a single lin (Oracle 10.2g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what changes are to be made to sqlplus to show all the data on a single lin [message #380359]

Sun, 11 January 2009 05:15

sqlstar_student
Messages: 42
Registered: November 2007

Member

Using Oracle 10.2g

The problem is that whenevr i run queries and collect the data into log and try to take the o/p.

It comes in multiples lines in sqlplus

ex

select* from facts_table;
 
UPN                                                       SID       ACYR
================================================== ========== ==========
        ID GRADE                                                        
========== ==================================================           
1140                                                      852       1998
         1 E                                                            
                                                                        
1140                                                      845       1998
         1 D                                                            
                                                                        
1140                                                      865       1998
         1 D

What settings need to be changed so that i can see all the data as
Its a trouble again to modify all the data to be shown properly in the logfile.


UPN SID ACYR ID GRADE
=== === ==== === =====

something like this.

Thank you.

Report message to a moderator

Re: what changes are to be made to sqlplus to show all the data on a single lin [message #380361 is a reply to message #380359]

Sun, 11 January 2009 05:42

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to enlarge line size (in SQL*Plus, issue SET LINESIZE 100 (or any other value)).

Report message to a moderator

Re: what changes are to be made to sqlplus to show all the data on a single lin [message #380370 is a reply to message #380359]

Sun, 11 January 2009 07:41

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Or try column formatting

Smile

Raj.

Report message to a moderator

Previous Topic:	SQL Updating with non unique criteria [merged]
Next Topic:	retrieve the least values from three tables and insert them into one table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 17 01:58:37 CDT 2025