get the best and fastest answer
|
|
|
|
Clear questions and runnable code get the best and fastest answer |
|
| PerlMonks |
Re: sqlplus hide passwordby BigJoe (Curate) |
| on Aug 23, 2006 at 14:28 UTC ( [id://569096]=note: print w/replies, xml ) | Need Help?? |
|
Personally I would ust DBI and build a simple interface. But this really depends on what you are trying to accomplish. DBI can actually do a lot of things that you can do from SQL*Plus. From the example you have here using this option would work pretty well.
Otherwise I would try Expect (http://search.cpan.org/~rgiersig/Expect-1.20/Expect.pod). you would pass the username and Database instance and expect would allow you to the then pass the password then any subsequent commands.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||