OraFAQ Forum: SQL & PL/SQL » issue of environment variable

Home » SQL & PL/SQL » SQL & PL/SQL » issue of environment variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

issue of environment variable [message #208125]

Fri, 08 December 2006 04:56

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

Report message to a moderator

Re: issue of environment variable [message #208127 is a reply to message #208125]

Fri, 08 December 2006 04:57

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Use:

col <column_name> format a50

the 50 above would be whatever length you actually need.

Report message to a moderator

Re: issue of environment variable [message #208138 is a reply to message #208125]

Fri, 08 December 2006 05:14

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.

Report message to a moderator

Re: issue of environment variable [message #208141 is a reply to message #208138]

Fri, 08 December 2006 05:21

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Then copy the code in sections.

Report message to a moderator

Re: issue of environment variable [message #208144 is a reply to message #208138]

Fri, 08 December 2006 05:36

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.

Report message to a moderator

Re: issue of environment variable [message #208150 is a reply to message #208144]

Fri, 08 December 2006 06:01

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?

Report message to a moderator

Re: issue of environment variable [message #208151 is a reply to message #208125]

Fri, 08 December 2006 06:03

jaydba
Messages: 86
Registered: September 2006
Location: UK

Member

I am connectng remote database through telnet. one of the member suggested buffersize option.

Report message to a moderator

Re: issue of environment variable [message #208152 is a reply to message #208151]

Fri, 08 December 2006 06:22

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 ?

Report message to a moderator

Previous Topic:	plz give sol of this query
Next Topic:	Filtering rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 05:56:40 CST 2024