USING claude for dynmic bind varibale query

[BADCODER]

Experts,

I am stumpted while writing a function returning USING clause based on query's bind vaiable?
Example:

Input Query:

SELECT C1, C2 FROM T1
WHERE C3 = :1
AND C4 = :2
AND C5 = 'GREAT'

Function OUTPUT string:

'USING p_C3, p_C4'

Thanks!!

 

[SantaMufasa]

Bad,

I, too, am a bit stumped...since I cannot devine what you want. Could you please provide more insight as to what code is not behaving as you expected, along with sample data.

Dave