Nice example.
A reader, October 13, 2004 - 10:14 am UTC
Great example!!!
Peter Tran, October 13, 2004 - 10:55 am UTC
As always, thanks for making it clear with an example.
Regards,
-Peter
Perfect
A reader, November 08, 2004 - 11:42 am UTC
A simple example that shows exactly how to do what you wanted
Great !!!!!
A reader, April 17, 2005 - 1:36 am UTC
Very good example
Hossein Alaei Bavil, May 04, 2005 - 6:34 am UTC
Excellent-- Just what I wanted to know!
A reader, July 07, 2005 - 8:12 pm UTC
thanks
Thanks!!
Hans Suvaal, October 05, 2005 - 5:03 am UTC
good work
mmdeo, March 09, 2006 - 12:21 am UTC
nice example
Oracle sql Call another sql files from if
Karoly, August 26, 2022 - 11:37 am UTC
Better mode:
col script_to_run new_value script_to_run
define call_function = 'y'
select case when upper(trim('$call_function')) in ('I','Y') then 'function.sql'
else 'skip.sql' end script_to_run
from dual;
prompt $script_to_run begin
@$script_to_run
prompt $script_to_run end
August 30, 2022 - 1:30 am UTC
Nice stuff.
Also conditional compilation is a candidate if you are running just PLSQL blocks
Best advice on how to move sql scripts with variable substitution
alexandre guerra, November 15, 2022 - 4:32 pm UTC
November 16, 2022 - 11:12 am UTC
Indeed, thanks for sharing