krithika

I think you will have to do some dynamic SQL, here is a URL on this site of a document that may help.

[url]http://www.dbasupport.com/dsc/ora8/page6.shtml[/url]

Mike