Home » SQL & PL/SQL » SQL & PL/SQL » sql result arrangement
sql result arrangement [message #220975] Thu, 22 February 2007 22:59 Go to next message
brihaspatirai
Messages: 24
Registered: November 2006
Location: pune
Junior Member
Hi,

when i enter query for any table
result comes like this
OWNER NAME TABLE_NAME MASTER_VIEW
------------------------------ ------------------------------ ------------------------------ -------
NEXT
----------------------------------------------------------------------------------------------------


but i want that it should come like

OWNER NAME TABLE_NAME MASTER_VIEW NEXT
-------------------------------------------------------------------------

if no data then it should not take space also

may i set enviorment for this or anything else plz suggest me

Thanks
Re: sql result arrangement [message #220976 is a reply to message #220975] Thu, 22 February 2007 23:22 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
At SQL prompt type


SQL> set linesize 300




You can find it in options (menu) as well.

Re: sql result arrangement [message #221050 is a reply to message #220975] Fri, 23 February 2007 08:02 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
brihaspatirai wrote on Thu, 22 February 2007 23:59


if no data then it should not take space also



What does that mean? And are there no punctuation characters on your keyboard? How do you expect to get a job with such poor grammar skills?
Re: sql result arrangement [message #221054 is a reply to message #221050] Fri, 23 February 2007 08:48 Go to previous message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Laughing

Well, Oracle will refuse to run if the grammer/syntax of his query will not be fine.
Previous Topic: Passing Variables from a Procedure to an XML.
Next Topic: problem with order by
Goto Forum:
  


Current Time: Sat Dec 07 00:00:10 CST 2024