Hi,
I've created some sql-install scripts. I want the user to execute them and I don't want the password to be in any file.
Now I'm invoking the batchfile this way:
sqlplus user/pass@INSTANCE @sql_load_all_whc_tables.sql
How can I start sqlplus that it doesn't ask for a username and pass on startup. It should rather come up with a sql prompt or something.
Because then I can do:
connect &user/&pass@&host
Any idea?
thx