Execute sql file with bind variable

Question

I would like to execute sql script through the use of bind variable because the file name will be known during runtime.

Like:

:name := 'test.sql';
@:name;

Help please.

noobie · Accepted Answer · 2014-08-29 08:41:26Z

1

Finally managed to get the file name by:

column col_name new_val var_name;

:name := 'test.sql';
select :name as col_name
from dual;

@&var_name;

answered Aug 29, 2014 at 8:29

noobie

4524 gold badges8 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1