Re: How do I access Oracle 8i tables from a korn shell script

check the man page on ksh for the << (Here Document) Example:
#!/bin/ksh

get_date () {
sqlplus -s << EOF
user/password
select sysdate from dual;
EOF
}

get_date > xxx.txt

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.sofbot.com/


---------------------------------------------------------