I downloaded data from a file to an Oracle table. The file had low values. In Schema Browser, I used a filter to do a search and my rows are selected, but once the low values are detected, the rest of the data becomes invisible. How do I get around this issue
Many windows programs interpret ASCII-0 values as “end of string”. Toad is one of them, and unfortunately, this isn’t configurable.
You can repeat the problem with this query:
with data as
(select ‘data’ || CHR(0) || ‘more data’ as text
from dual)
select *
from data;
You can work around it by replacing the ASCII 0 with something else, like this:
with data as
(select ‘data’ || CHR(0) || ‘more data’ as text
from dual)
select replace(text, CHR(0), ‘<ASCII 0>’) text
from data;