Some how in my oracle 11g database, the tables have got values such as "COMMERCE HOUSE â¿¿ 1" or "301 ÿ¿ÿ¿ÿ¿ÿ¢ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿". The datatype of the field is NVARCHAR2 (45). How can i query the database to get fileds having values other than [a-z], [A-Z],[0-9],[#,$,%,(,',-,2,)] from the table, in the particular field.
table name : address
{
address id number(10),
address1 nvarchar2(45)
}
Issue: To find out rows having values other than [a-z], [A-Z],[0-9],[#,$,%,(,',-,2,)].