Questions tagged [substitution-variables]

I've tried everything I can find on the internet but something's just not working. I've heard that you can use substitution variables in Oracle APEX SQL Workshop by putting a string that starts with an ampersand like so: SELECT * FROM orders WHERE…

I have a SQL script in which I declare some substitution variables at the top. The purpose of the script is to create a set of tables and views on a bunch of Oracle schemas when doing multi tenant deployment. In one of the scripts that creates…

So this is my code which I executed in sqllive online ide. declare fac number := 1; n number := &1; begin while n > 0 loop fac := n*fac; n := n-1; end loop; …