UNIX for Dummies Questions & Answers

HI Guys,

i just want ask the steps when trying to create a simple SQL select statement in linux.

I know how to use the select statement in SQLplus, but im having a difficult time in having a unix script connect direct to SQL plus and then retrieve the selected statement.

example.
supposed im in SQLplus my command is:

select employid, name, age from tablename;

how do is put it in a unix script?

thanks.

write this in your script...
if you wanna take that output in some variable..

if u think that u need only the output displayed from sqlplus.
u can try these,
#1. Output stored in a file

Code:

cat tablename.sql
set long 1024
set longchunksize 1024
set pagesize 0
set head off;
set linesize 1024;
set verify off
set feedback off
set termout off
set trimspool on
spool output.csv
select employid, name, age from tablename;
spool off;
exit;
 
 
sqlplus username/password @tablename.sql
cat output.csv

#2. To suprress the unwanted display,

use -s while calling sqlplus.
for eg : sqlplus -s username/password << EOF