Home » SQL & PL/SQL » Client Tools » sql pls (merged 2)
sql pls (merged 2) [message #529007] Fri, 28 October 2011 02:40 Go to next message
chawach
Messages: 5
Registered: October 2011
Junior Member

hi all,
why i cant see all the resulat of a query, i set line 32767 and the buffer 1000,and still i cant see all the result,the scroll bar dnt move right side
Re: sql pls [message #529008 is a reply to message #529007] Fri, 28 October 2011 02:42 Go to previous messageGo to next message
Littlefoot
Messages: 21446
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's a shame.

What tool do you use? Which query did you run? Are you sure it is supposed to return some result?

If possible, switch to SQL*Plus and copy/paste the whole session so that we could see what you did and how Oracle responded.
Re: sql pls [message #529010 is a reply to message #529008] Fri, 28 October 2011 02:51 Go to previous messageGo to next message
chawach
Messages: 5
Registered: October 2011
Junior Member

i did it and it dosnt work
Re: sql pls [message #529011 is a reply to message #529010] Fri, 28 October 2011 03:16 Go to previous messageGo to next message
Littlefoot
Messages: 21446
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What did you do? Show us!

How to ask questions the smart way?
Re: sql pls [message #529024 is a reply to message #529010] Fri, 28 October 2011 04:48 Go to previous messageGo to next message
pablolee
Messages: 2880
Registered: May 2007
Location: Scotland
Senior Member
chawach wrote on Fri, 28 October 2011 08:51
i did it and it dosnt work

then you most likely did it wrongf. However, nobody can tell whether you did it wrong and what it was that you did wrong, because you failed to show us exactly what you did.
Re: sql pls [message #529035 is a reply to message #529024] Fri, 28 October 2011 06:54 Go to previous messageGo to next message
chawach
Messages: 5
Registered: October 2011
Junior Member

when i execute a query with too many fields and record, the sqlplus dnt show me the result cz the scoll bar didnt move on the right side,i changed the line to 32767 and the buffer to 1000,but still cant see all the fields.i had the same oracle on win xp with no problems,but on win 7 there is prob
Re: sql pls [message #529102 is a reply to message #529035] Fri, 28 October 2011 12:55 Go to previous message
Littlefoot
Messages: 21446
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I really don't know what you are talking about, but - if it is the CMD window size, then open its properties, navigate to Layout tab and enlarge Window Size width and/or height values.
Previous Topic: if you liked classic SQL Plus , what now?
Next Topic: Date format and calendar type are not changing in oracle form
Goto Forum:
  


Current Time: Wed Nov 14 11:20:16 CST 2018