Scenario: Column with data including the Space - ASCII character
Posted on 2014-01-21
I have 10 tables and each table has 10 columns and each column is of datatype varchar2. Data in these columns could be including spaces. Just wanted to stress here, trim cannot be used here. This is an ASCII character. I will have to return column name and table name which has columns with data with space - ASCII character at the end of varchar2 ..
Could you please suggest how I do that..
Quick reply is appreciated..