Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Shell Scripts/PW Security
In order to do this, the shell script should contain:
sqlplus /nolog @sqlscript_to_run remote_sqlservice
And 'sqlscript_to_run' should contain:
connect username/password@&&1
before any SQL statements.
Hope this helps.