Home » SQL & PL/SQL » SQL & PL/SQL » Display out put format in SQL *plus (oracle 9i)
icon5.gif  Display out put format in SQL *plus [message #308670] Tue, 25 March 2008 02:59 Go to next message
Messages: 23
Registered: February 2008
Location: Tamil Nadu, India
Junior Member
Hi to all,

I have table with large size of columns..

When i trying to display all records from that table, it displays unformatted like columns displayed in another row

How to set the column and page size to display the correct format?
Re: Display out put format in SQL *plus [message #308675 is a reply to message #308670] Tue, 25 March 2008 03:22 Go to previous message
Michel Cadot
Messages: 64948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set linesize
set pagesize
set ...

Previous Topic: Query for Retrieving first 2 records of an employee
Next Topic: insert (merged)
Goto Forum:

Current Time: Fri Jun 23 03:49:07 CDT 2017

Total time taken to generate the page: 0.08948 seconds