Home » SQL & PL/SQL » Client Tools » Extract file format in toad (11g)
icon9.gif  Extract file format in toad [message #630217] Tue, 23 December 2014 03:48 Go to next message
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 #630228 is a reply to message #630217] Tue, 23 December 2014 06:27 Go to previous messageGo to next message
BlackSwan
Messages: 25796
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Re: Extract file format in toad [message #630253 is a reply to message #630228] Tue, 23 December 2014 14:08 Go to previous message
Littlefoot
Messages: 21331
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.
Previous Topic: Design menu option missing
Next Topic: How to generate Control File Definition in Oracle SQL Developer
Goto Forum:
  


Current Time: Fri Jan 19 16:44:04 CST 2018

Total time taken to generate the page: 0.07457 seconds