in reply to sqlplus hide password
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.
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