In SQL Developer 3.2 and above (some) versions I was able to define multiple variables on a single line. However, in 4.1.5, when I run the statement, the database/memory ONLY captures the first variable and the rest are ignored. Below is an example of what I am talking about:
In 3.2 - I could define/initialize multiple sourcefile's like this:
define sourcefile = 'jan.txt', 'feb.txt', 'mar.txt';
However, in 4.1.5 the above statement does not work. I have to define sourcefiles in different lines AND run them individually...which is a major pain.
define sourcefile = 'jan.txt';
define sourcefile = 'feb.txt';
define sourcefile = 'mar.txt';
I really appreciate the help. Thanks!!