user3937182 wrote:I would simply extract application source code from my Source Code Repository; then do as below
We need to scan View code using queries like:
where text like '%bad_code%';
but, because of the LONG datatype of the TEXT column, we can't.
Any alternatives ?
The TO_LOB function can convert the LONG to a CLOB but only when used in an INSERT statement.
create view emp_vw as select * from emp desc user_views create table my_views (view_name varchar2(30), text clob) insert into my_views select view_name, to_lob(text) from user_views