Connect to oracle db using shell script

Shell Programming and Scripting
1

Hi,
I want to connect to oracle db using unix shell script. And i want to retrieve data from db through shell script.

Please help me as soon as possible.

Thanks,

J.P. Das

2

Try this:

sqlplus -s uid/pwd@schema <<EOF
Variable declaration
begin
sql commands;
end;
exit;
EOF