OraFAQ Forum: Unix » Write file into Unix

Home » Infrastructure » Unix » Write file into Unix

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

Write file into Unix [message #226092]

Thu, 22 March 2007 08:44

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.

Report message to a moderator

Re: Write file into Unix [message #226097 is a reply to message #226092]

Thu, 22 March 2007 09:24

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

Report message to a moderator

Re: Write file into Unix [message #226100 is a reply to message #226097]

Thu, 22 March 2007 09:34

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.

Report message to a moderator

Re: Write file into Unix [message #226103 is a reply to message #226092]

Thu, 22 March 2007 09:39

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.

Report message to a moderator

Re: Write file into Unix [message #226158 is a reply to message #226103]

Thu, 22 March 2007 12:33

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

Report message to a moderator

Re: Write file into Unix [message #226595 is a reply to message #226158]

Sun, 25 March 2007 10:02

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.

Report message to a moderator

Re: Write file into Unix [message #226769 is a reply to message #226595]

Mon, 26 March 2007 08:48

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?

Report message to a moderator

Re: Write file into Unix [message #226785 is a reply to message #226769]

Mon, 26 March 2007 09:19

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 ?

Report message to a moderator

Re: Write file into Unix [message #226793 is a reply to message #226785]

Mon, 26 March 2007 09:34

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

Report message to a moderator

Re: Write file into Unix [message #226805 is a reply to message #226785]

Mon, 26 March 2007 10:38

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.

Report message to a moderator

Re: Write file into Unix [message #226877 is a reply to message #226805]

Mon, 26 March 2007 16:55

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.

Report message to a moderator

Re: Write file into Unix [message #228395 is a reply to message #226092]

Mon, 02 April 2007 22:31

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.

Report message to a moderator

Previous Topic:	ORA-01031 for Oracle User
Next Topic:	dbora for oracle 10g not working in solaris 10

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 16 12:52:15 CDT 2026