Any way to automate input for input prompts
697586May 14 2009 — edited May 14 2009Hi all,
For times when there is a input prompt, is there any method/way we can direct pass it in via unix scripting or sql script? Specially for password change in this scenario, which is database's default prompting.
Eg. I wanna change a user password. however there will be an input prompt. any way I can automate the input passing in? I understand that we can use "alter user" , but I am trying to stick to using password [username] to perform the change.
SQL> password [username];
password:
Thanks in advance.
Eugene