 Extract file format in toad [message #630217] |
Tue, 23 December 2014 03:48  |
 |
Neerajpant
Messages: 1
Registered: December 2014
|
Junior Member |
|
|
How can i get my extract of table in a text file in the following format in toad-
"64","abc123","sd",
"34","xyz","pder",
There are no whitespaces(As in first record the length of column is 10 but length of actual data is 2 but there are no whitespaces).
Currently the query i am using is,
Set trims on;
Set Colsep ",";
spool 'c:\extract\q.txt';
select * from 'Table_1';
spool off;
[Updated on: Tue, 23 December 2014 04:39] Report message to a moderator |
|
|
|
|
|
| Re: Extract file format in toad [message #630253 is a reply to message #630228] |
Tue, 23 December 2014 14:08  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
GUI offers a savior - right click. So, do that in Data Grid output. Choose "Export dataset" from the context menu. Set export format to "delimited text", specify destination, pick what you want to do with number / string quoting (double quote will be your choice, I presume) and - finally - click OK. That would result in output you posted in the first message.
However, I have no idea what
Neerajpant
There are no whitespaces(As in first record the length of column is 10 but length of actual data is 2 but there are no whitespaces).
means. There's nothing like that in your first message. Or, if it is, I can't see it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
