title: how to create a user in oracle using SQL*PLUS by running a script from txt file that will prompt me for 2 parameters (username, password)
body: <p>I have a question about creating users in Oracle using SQL*PLUS. But what I want to do is write the syntax in a txt file first (script) then when I run the script by calling it using the @ or by copy/past it should prompt me for two parameters (user name and a password). I searched through the web and read 2 books and I still can't find the right syntax. </p>