how can i run sql patch from unix shell like this:
sql "to log in sql"
update table1 set flag=1 where stat=1;
commit;
exit "to exit from sql"
I want to run it on the crontab but on this way it didnt work
how about (say sqlplus was the sql program)
sqlplus ..... <<EOF
update .......;
commit;
quit;
EOF
thanks porter
but how can i switch the user on the unix scrip with intering the user name and the password
thanks in advance
I thought you would have the user and password on the command line for sql[plus] (is it oracle?).
look porter
our system (unix) is directly enter to sql by typing just the word "sql"
but I think if the system need from me the pass and the user mane I have to do that: sqlplus username/pass@login
is that right?
so no problem now for me because the script ran successfuly thanks porter
but I face this problem when I want to switch the user on unix how can do that
how can I give the system the user name and the pass through the script file
again thanks porter
