Hi,
I came across a situation where I've to pass comment in SQL through ODI tools.
But there are constraint ODI it supressing full line comments and multiple line comments.
I've tried my approaches and comments , Comments inside SQL statement is being suppresed by ODI
What I found that that if I place My comment after then hint command optimizer taking it.
Above embedded link has spool too.
I just want to confirm if I in below SQL hints(any hint) would ignore by oracle or are they good to go and optimizer will take the correspondent hint and ignore the rest comment.
Insert /*+append*/ into some_table
Insert /*+append My comments as per my business requirement*/ into some_table