How to execute a sql script from a sub directory?
5108Sep 13 2007 — edited Sep 13 2007Hi,
I have the following directories & files.
c:\oracle\
install.sql
tablescript\
loadtable.sql
table1.sql
table2.sql
Contents of install.sql file:
@tablescript\loadtable.sql;
Contents of loadtable.sql file:
@table1.sql;
@table2.sql;
However, when I run install.sql, sqlplus complaints unable to find the file loadtable.sql.
So, my question is how to make my install.sql able to execute loadtable.sql.
Of course, it can work if i hardcode the full path to @c:\oracle\tablescript\loadtable.sql and but I would like to know how to get it work without hardcode the path.
Please advise.
Thanks.
Regards,
Jap.
Message was edited by:
bchurn