Exporting Result to Text file through Query [message #572522] |
Wed, 12 December 2012 22:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/92f55a7d14f2b3276c67fe12c2daf33c?s=64&d=mm&r=g) |
srikanth_d5
Messages: 39 Registered: June 2012 Location: hyderabad
|
Member |
|
|
Hi Experts,
I'm running this query on sql developer trying to export large file but its not executing.
set head off
spool c:\myoracle.txt
select txt_name_insurer||'~'||txt_policy_number from Table_Name where rownum<'10';
spool off
set head on
Error:- line 1: SQLPLUS Command Skipped: set head on
Kindly guide me please
Thanks and Regards
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Exporting Result to Text file through Query [message #572960 is a reply to message #572957] |
Wed, 19 December 2012 00:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21808 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Excel version is OK, so I'd go with SQL Developer upgrade.
I don't know what will it look like; normally, I'd expect upgraded version to retain previous version's settings. However, your version is much lower than the one you'd upgrade to, so ... no idea. Google a little bit, maybe you'll find the answer. Or, wait some more - someone here might know better.
[Updated on: Wed, 19 December 2012 00:53] Report message to a moderator
|
|
|