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
kathiresan.c
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set linesize
set pagesize
set ...

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


Current Time: Sat Dec 10 15:00:18 CST 2016

Total time taken to generate the page: 0.19488 seconds