4 Replies Latest reply: Jan 4, 2013 5:40 AM by ranit B RSS

    How to fetch the junk values of a column and the column name in oracle


      Can anyone help me in writing a procedure/dynamic SQL to fetch the column where the junk values appears and its value. Eg: If emp table contains ID and Name columns, and ID column contains junk values, the result should be the Id column and the junk value/s. It should be dynamic because next time if the other column contains junk values(like $,%...), the query should display the other column too..

      Thanks in advance..