When the query is built, are the substitution parameters fixed or dynamically generated?
For example, ...AND p_name LIKE '%apple%', --- is "apple" fixed or dynamic generated?
o_orderdate >= to_date ('1993-09-01', 'YYYY-MM-DD') --- is '1993-09-01' fixed or dynamic generated?
The data is generated randomly, but since the random number generator is seeded with the virtual user ID, it will have the same sequence.
