At the time of running sql scripts it is asking my sourcepath,TNS entry, and password in command prompt I am providing these values(whenever I run script I need to give this values)I am getting these values in my sql script,now I want to provide these values from properties file to run my scripts.Can I get these values from properties files.
What do you use for executing sql scripts? Is it sqlplus? if so
Joined: Dec 21, 2006
thanks for your reply,
I don't know exactly how to run these scripts. my database admin is running these scripts at the time of running scripts it is asking path.tns name and password, I want get these fields from properties file I need to get these values in script file it self. now I am taking from command prompt.
To run an SQL script, select one of the following options from the Run menu:
All - Runs your SQL script from the beginning to the end. If an error occurs and the Stop on Error option is turned on, the program stops and the statement where the error occurred remains selected.
From Selected - Starts your SQL script from the first statement that is selected or from the current cursor position and continues to the end of the script.
Selected - Runs the statements that are selected.
The results are added to the end of the Messages tab. If the Smart Statement Selection option on the Options menu is not checked, the text that is selected is run as a single SQL statement.