Home » SQL & PL/SQL » SQL & PL/SQL » Trim query (Oracle 9i under wndows 2k)
Trim query [message #288792] Tue, 18 December 2007 13:49 Go to next message
sajuks
Messages: 1
Registered: December 2007
Junior Member
Hi All,

I have a table TABLEA with two fields say name varchar(10),desc varchar(240).
We want to save the o/p of this into a csv file and have created a batch file with the output as
select name,desc from tablea

the problem is that when we open the data in csv file , the columns have expanded to fill in the 10 &250 size. The o/p in excel is not proper to look at. i tried using trim but still it is giving us problem
Using TOAD if i do a copy and paste into csv/xls then it gives the proper desired format.
Please advic
Re: Trim query [message #288796 is a reply to message #288792] Tue, 18 December 2007 14:05 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and "set trimout off"

Regards
Michel
Previous Topic: select over filter
Next Topic: Updating multiple records
Goto Forum:
  


Current Time: Wed Dec 07 10:36:39 CST 2016

Total time taken to generate the page: 0.14208 seconds