Hi All,
We have a customer table and there around 2 Cr records, we observer there are blank spaces in customer_id VARCHAR2(50) column.
We have to find the records with blank space, space is anywhere, in starting, at last and in-between also. somewhere there arw 2 and 3 apace also.
We tried to find using REGEX and TRIM but no luck, its showing some of the records where there is not a single space too.
Requesting for help if someone faced such issue and got solution.
We are at oracle 12.2.
Thanking you!!