Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows:
update jobs set JOBSTATE = 3 where APPID = 5 ;
I do not want users to be opening the script and be putting username, password and database name when they want to run the script but I want to include the username, password and database name inside the script so that when they just run it will automatically log in and update the table.
Please How can I write such SQL script? So that users will not have reason to be editing the script.
Idongesit Daniel Udoh
January 21, 2008 12:06 PM
January 23, 2008 8:16 PM