When comment is marked inside sql statement like
insert into some_table
select /*+full(T1) */
/*This is my comment part which is being suppress*/
-- This comment also
from db_table T1;
when the above statement is being executed by ODI the comment part is begin suppress on looking into V$SQL table the comment part is not appeared.
Is there any workaround to skip the method of ODI of suppressing comment from SQL statements