Query that u hav sent seem prtty complex to me..it may be bcoz im not a plsql developer..i use plsql very often..
But Now wen u hav already told me abt this query ..i tried it and put the required values to it.still its nt working...i changed the table_name given by u and put there my table name.Nt working..