I want to run a set
of sql scripts while releasing the application. These sql scripts
contain certain variable that need to be replaced while executing the
query. A sample statament is:
"SELECT *
FROM
<HRISDB::SERVER_NAME>.<HRISDB::DB_NAME>.<HRISDB::DB_OWNER>.vNewHire
hr"
Where I want to
replace
<HRISDB::SERVER_NAME>,<HRISDB::DB_NAME>,<HRISDB::DB_OWNER>
with the respective values stored as properties.
Each script file
contain multiple statement where in I need to replace the values.
Any pointers to
resolve the same will be helpful
Thanks
Shelly
