I was thinking that it's kind of annoying to work with dynamic SQL in PL/SQL. It would be much easier if you could have syntax highlighting, auto format .
I realize this would be difficult Toad to manage on it's own. However what if you could add a hint to tell Toad to do this? For example:
-- <<next-string-is-dynamic-sql>>
l_dynamic_sql VARCHAR2(10000) := q'<
select 1 from dual
>';
Or
l_dynamic_sql VARCHAR2(10000) := q'<
/*<Toad-please-forma-sql-in-string-here>*/
select 1 from dual
/*<Toad-please-forma-sql-in-string-here-end>*/
>';
This would be kind of the opposite of something I've talked about here before. Implementation for them might be closely related though.