Home » SQL & PL/SQL » SQL & PL/SQL » issue of environment variable
issue of environment variable [message #208125] Fri, 08 December 2006 04:56 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

I am trying to run one of the query which is quite lenghty. I am able to run it through toad successfully. But, when I copy and put this script into sqlplus prompt then it truncate the lenght(columns) of charcters.

Is there any options available to set it properly.

I tried to set ARRAY ISZE, LINESIZE but unfortunately I could get it.

Can you please suugest me the the approprate environment variable and value?

Thanks in advance
Re: issue of environment variable [message #208127 is a reply to message #208125] Fri, 08 December 2006 04:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Use:

col <column_name> format a50

the 50 above would be whatever length you actually need.
Re: issue of environment variable [message #208138 is a reply to message #208125] Fri, 08 December 2006 05:14 Go to previous messageGo to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

I do not want to disply indvidul column format. The main problem is that when I copy and paste from editor it truncate characters at the time of executing the original script.
Re: issue of environment variable [message #208141 is a reply to message #208138] Fri, 08 December 2006 05:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Then copy the code in sections.
Re: issue of environment variable [message #208144 is a reply to message #208138] Fri, 08 December 2006 05:36 Go to previous messageGo to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

That's the problem. when I copy to SQLPLUS section then it trims the characters of each line from the right hand size. Hope the issue would be cleared now.
Re: issue of environment variable [message #208150 is a reply to message #208144] Fri, 08 December 2006 06:01 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I've never experienced SQL*Plus right truncating each line from a copy/paste. Are you using a certain terminal emulator or anything special?
Re: issue of environment variable [message #208151 is a reply to message #208125] Fri, 08 December 2006 06:03 Go to previous messageGo to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

I am connectng remote database through telnet. one of the member suggested buffersize option.
Re: issue of environment variable [message #208152 is a reply to message #208151] Fri, 08 December 2006 06:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
To my knowledge there is not BUFFERSIZE command for SQL*Plus. I wonder if you issue 'ed' while in SQL*Plus and then paste the lines in the resulting window if the lines will still be truncated ?
Previous Topic: plz give sol of this query
Next Topic: Filtering rows
Goto Forum:
  


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

Total time taken to generate the page: 0.10286 seconds