Home » Infrastructure » Unix » Write file into Unix
Write file into Unix [message #226092] Thu, 22 March 2007 08:44 Go to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Hi all.

I used UTL_FILE to write my output to Unix. I have 160 character lines. The window split my lines by two. There is anyway to set up my Unix screen so I can see all 160 characters in one line?

Thank you in advance.
Re: Write file into Unix [message #226097 is a reply to message #226092] Thu, 22 March 2007 09:24 Go to previous messageGo to next message
jheronimus
Messages: 11
Registered: March 2007
Location: The Netherlands, Groninge...
Junior Member
You created text file on the UNIX file system, right?

But how do you review this textfile, in vi or with cat or what?


Jeroen de Jong
Re: Write file into Unix [message #226100 is a reply to message #226097] Thu, 22 March 2007 09:34 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member

Yes. I created a text file on the Unix. I used cat to view my file. I also tried vi but still saw my 160 character lines split by two.
Re: Write file into Unix [message #226103 is a reply to message #226092] Thu, 22 March 2007 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you have an 80 column window, then "unix" is forced to "split" the line to present it to you.
But most likely the record is still 160 characters in the file.
P.S.
What does this question have to do with SQL or PL/SQL?
You have a data presentation issue from *nix not Oracle.
Re: Write file into Unix [message #226158 is a reply to message #226103] Thu, 22 March 2007 12:33 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
I used utl_file to read data from oracle database then write output on Unix
Re: Write file into Unix [message #226595 is a reply to message #226158] Sun, 25 March 2007 10:02 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Correction unix will not split the lines, it is getting wrapped. Having said that i am not able understand what is exactly your problem.
Re: Write file into Unix [message #226769 is a reply to message #226595] Mon, 26 March 2007 08:48 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Thanks. I know that it's getting wrapped. But I would like to ask if there is anyway I can have my output display on screen in one line?

Re: Write file into Unix [message #226785 is a reply to message #226769] Mon, 26 March 2007 09:19 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
To my knowledge i don't think it is possible unix atleast in "vi". Again i am going to ask you the same question why do you want to see in a single line rather than two or n lines ?
Re: Write file into Unix [message #226793 is a reply to message #226785] Mon, 26 March 2007 09:34 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Im not really clear on what you are after but if you are talking about the line size from utl_file you should read this
Re: Write file into Unix [message #226805 is a reply to message #226785] Mon, 26 March 2007 10:38 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Thanks much for your responses. The reason I would like to see the output in one line because that is the requirement.
Re: Write file into Unix [message #226877 is a reply to message #226805] Mon, 26 March 2007 16:55 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
I am sorry dude if that is the case then a new editor need to be written for unix to show in a single line. All the very best.
Re: Write file into Unix [message #228395 is a reply to message #226092] Mon, 02 April 2007 22:31 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
vi or cat will split a 120 charter line, it has no choice given your screen is 80 charter wide.
Previous Topic: ORA-01031 for Oracle User
Next Topic: dbora for oracle 10g not working in solaris 10
Goto Forum:
  


Current Time: Fri Mar 29 07:45:14 CDT 2024