any one help


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
any one help

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
# 2  
how about (say sqlplus was the sql program)

sqlplus ..... <<EOF
update .......;
commit;
quit;
EOF
# 3  
thanks porter
but how can i switch the user on the unix scrip with intering the user name and the password

thanks in advance

Smilie
# 4  
I thought you would have the user and password on the command line for sql[plus] (is it oracle?).
# 5  
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

Smilie
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #201
Difficulty: Easy
Perl is implemented as a core interpreter, written in C, together with a large collection of modules, written in Perl and C.
True or False?

Featured Tech Videos