how the command works in unix

September 14, 2011 at 00:43:59
Specs: Windows XP
sqlplus / command in unix

See More: how the command works in unix

Report •

#1
September 14, 2011 at 10:02:12
Here is an example of a Oracle's sqlplus script using a Unix HERE document sending the output to file mytestdatafile.txt:

$ORACLE_HOME/bin/sqlplus -S "$LOGIN/$PW" << EOF > mytestdatafile.txt
SET HEADING OFF
SET WRAP ON
SET PAGESIZE 0
SET LINESIZE 4000
SET FEEDBACK OFF
SET RECSEP OFF
SET VERIFY OFF

select joid, job_name, job_type from job;
exit;
EOF

Search computing.net for other examples using sqlplus.


Report •
Related Solutions


Ask Question