Data compare output SQL file - DECLARE sections
null_value CHAR(#) := NULL;
statement1 := 'some statement'
EXECUTE IMMEDIATE statement1 USING 'some values'
1. How can I make each DECLARE section only be for one table, as it sometimes contains more than one.
2. How do I limit the number of statements included for execution in the DECLARE section. Seems to be currently limited to around 160 and I want to make it less.
3. Is there a way to output multiple SQL files instead of one large one?