How to UNION ALL xxx_VIEWS and xxx_SOURCE ?

I often build a view to prototype/develop ETL transformation rules, then "wrap" the view in a PL/SQL package. Occasionally, I need to search the ETL code. However, xxx_VIEW.TEXT is LONG, while xxx_SOURCE is VARCHAR2(4000). I know I can run t...

Read More...

---