<div>
You may use SQL*Plus concatenation &quot;||&quot;. You'd better set feedback off also.<br />
<br />
#!/bin/sh<br />
sqlplus scott/tiger 2&gt;/dev/null &lt;&lt;EOC<br />
set heading off feed off term off<br />
<br />
spool flat.txt<br />
select ename || '|' || job || '|'<br />
from emp;<br />
spool off<br />
quit<br />
EOC<br />
<br />
# flat.txt lists ename and job, delimited by &quot;|&quot;.<br />
# Each line is terminated by &quot;|&quot;. You may<br />
# use Unix utilities such as sed, awk to process it<br />
<br />
Regards.<br />

</div>


You may use SQL*Plus concatenation "||". You'd better set feedback off also.

#!/bin/sh
sqlplus scott/tiger 2>/dev/null <<EOC
set heading off feed off term off

spool flat.txt
select ename || '|' || job || '|'
from emp;
spool off
quit
EOC

# flat.txt lists ename and job, delimited by "|".
# Each line is terminated by "|". You may
# use Unix utilities such as sed, awk to process it

Regards.


<div>
Thanks bira.<br />
<br />
Habboy
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am new to unix and would like to write a script that would allow me to extract 2 fields from an oracle database and write them out to a flat file.<br />
Could someone point me in the right direction.<br />
<br />
Thanks
</div>
</div>


Hi,

I am new to unix and would like to write a script that would allow me to extract 2 fields from an oracle database and write them out to a flat file.
Could someone point me in the right direction.

Thanks

retrieving data from oracle to flat file

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.