|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with Fixed width File Parsing | sate911 | UNIX Desktop for Dummies Questions & Answers | 4 | 05-19-2008 12:18 PM |
| Changing particular field in fixed width file | dsravan | Shell Programming and Scripting | 4 | 02-11-2008 06:08 PM |
| Converting a Delimited File to Fixed width file | raghavan.aero | Shell Programming and Scripting | 2 | 06-06-2007 03:44 PM |
| adding delimiter to a fixed width file | sumeet | Shell Programming and Scripting | 2 | 03-21-2007 10:19 AM |
| Fixed Width file using AWK | alok.benjwal | UNIX for Dummies Questions & Answers | 2 | 12-05-2005 11:39 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread |
Rating: 
|
Display Modes |
11-19-2001
|
||||
|
||||
Increase width of Spool file
Hi All
This may not be entirely Unix related but I'll just have to try my luck and see if you know how to do this: I need to spool the results of my SQL query into a file but as there are too many fields in the query the resultant spool file put the last few fields on the next line. May I know if there is a way to expand the spool file so that all the fields in a particular record are displayed in the same line? I'm using HP9000 Unix system and SQLPLUS to perform my query, the query I used in the SQL prompt is: Spool CHNSHP select a.part_nr, a.commercial_dn, a.part_dn, b.NAT_HS_CD as CHN_HTS from cla_part a, clv_curr_cust_part_ctry b where b.part_nr= a.part_nr and a.part_nr in ('A6016A', 'A6016A 0D1', |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
