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)
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 Go to next message
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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)).
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 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Or try column formatting

Smile
Raj.
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:
  


Current Time: Thu Dec 08 14:22:07 CST 2016

Total time taken to generate the page: 0.10723 seconds